Go to primary content
Oracle® Product Lifecycle Analytics Multi-Dimensional Schema Data Reference Manual
Release 3.6
E84200-01
Next
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction
Introduction
Acronyms
What's New in Oracle Product Lifecycle Analytics 3.3.1.0.0
2
Oracle Product Lifecycle Analytics Data Model
Naming Conventions for Multi-Dimensional Schema Tables
Standard Table Prefixes
Standard Table Suffixes
Standard Column Prefixes
Standard Column Suffixes
Table Types in Oracle Product Lifecycle Analytics Schema
ETL Control Entities
Fact Tables
Dimension Tables
Dimension Entities
Bridge Tables
Data Tables
Staging Tables
Materialized Views
Data Validation Rules
User Defined Extensions
User Defined Columns in the Fact Tables
User Defined Columns in the Dimension Tables
Prefixes to the User Defined Columns
User Defined Dimension Tables
User Defined Bridge Tables
3
Entity-Relationship Diagrams
Problem Reports
Problem Reports Fact
Problem Reports Item Fact
Problem Reports - Workflow Detail
Non Conformance Reports
NCR Fact
NCR Workflow Detail
Corrective and Preventative Actions
CAPA Fact
CAPA Item
CAPA Workflow Detail
Audit
Audit Fact
Audit Item
Audit Workflow Detail
Deviations
DEV Fact
DEV Item Fact
DEV Sign-off Fact
DEV Workflow Detail
Engineering Change Order
ECO Fact
ECO Item Fact
ECO Sign-off Fact
ECO Workflow Detail
Engineering Change Request
ECR Fact
ECR Item Fact
ECR Workflow Detail Fact
ECR Sign-off Fact
Item
Item Fact
Manufacturer Part Fact
Item Manufacturer Part Fact
Manufacturer Change Order
MCO Fact
MCO Item Fact
MCO Signoff Fact
MCO Workflow Detail Fact
Stop Ship
Stop Ship Fact
Stop Ship Item Fact
Stop Ship Signoff Fact
Stop Ship Workflow Detail Fact
PPM
PPM - Activity
PPM - Baseline
PPM - Phase Gate
Phase Gate Singoff
PPM - Portfolio
PPM - Project Cost
PPM Project Details
PPM Project Details, Signoff
PPM Project Details, Workflow
PPM - Project Summary
PPM - Project Forecast Revenue
PPM - Program
PPM - Snapshot
4
Schema Data Reference
BI_DATA_DICTIONARY
BRIDGE_CTL
CLASS_INFO_D
CUSTOMER_D
DOC_CATEGORY_D
DOC_CONF_MGMT_1_D
DOC_CONF_MGMT_2_D
DOC_CONF_MGMT_3_B
DOC_CONF_MGMT_3_D
DOC_ERP_1_D
DOC_ERP_2_D
DOC_ERP_3_B
DOC_ERP_3_D
DOC_MANUF_1_D
DOC_MANUF_2_D
DOC_MANUF_3_B
DOC_MANUF_3_D
DOC_PROD_ENG_1_D
DOC_PROD_ENG_2_D
DOC_PROD_ENG_3_B
DOC_PROD_ENG_3_D
DOC_TYPE_D
EVENT_TYPE_D
FLAG_D
INT_ORGANIZATION_D
ITEM_ASSEMBLY_RATING_D
ITEM_CATEGORY_D
ITEM_COMMODITY_1_D
ITEM_COMMODITY_2_D
ITEM_COMMODITY_3_B
ITEM_COMMODITY_3_D
ITEM_COMMODITY_D
ITEM_COMP_ENG_1_D
ITEM_COMP_ENG_2_D
ITEM_COMP_ENG_3_B
ITEM_COMP_ENG_3_D
ITEM_COMPLIANCE_1_D
ITEM_COMPLIANCE_2_D
ITEM_COMPLIANCE_3_B
ITEM_COMPLIANCE_3_D
ITEM_COMPLIANCY_D
ITEM_COMPONENT_ENGINEER_D
ITEM_COST_RATING_D
ITEM_CUST_SUPP_1_D
ITEM_CUST_SUPP_2_D
ITEM_CUST_SUPP_3_B
ITEM_CUST_SUPP_3_D
ITEM_D
ITEM_ECRSS_F
ITEM_ERP_1_D
ITEM_ERP_2_D
ITEM_ERP_3_B
ITEM_ERP_3_D
ITEM_F
ITEM_FAILURE_MODE_D
ITEM_LIFECYCLE_RATING_D
ITEM_LIFECYCLE_STATE_D
ITEM_MFR_PART_DATA
ITEM_MFR_PART_PREFER_STATUS_D
ITEM_PART_FAMILY_D
ITEM_PERFORMANCE_RATING_D
ITEM_PROD_ENG_1_D
ITEM_PROD_ENG_2_D
ITEM_PROD_ENG_3_B
ITEM_PROD_ENG_3_D
ITEM_PRODUCTLINE_B
ITEM_PRODUCTLINE_D
ITEM_RELIABILITY_RATING_D
ITEM_REV_D
ITEM_SIZE_D
ITEM_SUPPLIER_B
ITEM_TLA_D
ITEM_TYPE_D
MANUFACTURER_D
MDS_BI_INDEXES
MDS_LISTDIM_CTL
MDS_REV_VIEW_ECRSS
MFR_COMPLIANCE_D
MFR_COUNTRY_D
MFR_LIFECYCLE_PHASE_D
MFR_LOCATION_D
MFR_PART_ASSEMBLY_RATE_D
MFR_PART_COMMODITY_1_D
MFR_PART_COMMODITY_2_D
MFR_PART_COMMODITY_3_B
MFR_PART_COMMODITY_3_D
MFR_PART_COMP_ENG_1_D
MFR_PART_COMP_ENG_2_D
MFR_PART_COMP_ENG_3_B
MFR_PART_COMP_ENG_3_D
MFR_PART_COMP_ENG_D
MFR_PART_COMPLIANCE_1_D
MFR_PART_COMPLIANCE_2_D
MFR_PART_COMPLIANCE_3_B
MFR_PART_COMPLIANCE_3_D
MFR_PART_COMPLIANCE_D
MFR_PART_COST_RATE_D
MFR_PART_F
MFR_PART_LIFECYCLE_PHASE_D
MFR_PART_LIFECYCLE_RATE_D
MFR_PART_PARTFAMILY_D
MFR_PART_PERF_RATE_D
MFR_PART_RELIABILITY_RATE_D
MFR_PART_SUPPLIER_B
MFR_PART_TYPE_D
MFR_QMS_STANDARD_B
MFR_QMS_STANDARD_D
MFR_REGION_B
MFR_REGION_D
MFR_SIZE_D
MFR_STATE_D
MFR_TYPE_D
PC_CUSTOMER_D
PC_DEV_CATEGORY_D
PC_DEV_CUSTOMER_B
PC_DEV_F
PC_DEV_FIELD_D
PC_DEV_FINISHEDGOODS_D
PC_DEV_FUNCTION_D
PC_DEV_IDEA_TYPE_D
PC_DEV_ITEM_DATA
PC_DEV_ITEM_PRODUCTLINE_B
PC_DEV_MANUF_OWNER_B
PC_DEV_MFRLOCIMPACT_B
PC_DEV_MFRLOCIMPACT_D
PC_DEV_ONORDER_D
PC_DEV_PRGTASK_B
PC_DEV_PRGTASK_D
PC_DEV_PRIORITY_D
PC_DEV_PRODUCTLINE_B
PC_DEV_PROGRAM_B
PC_DEV_PROGRAM_D
PC_DEV_QUALITY_OWNER_B
PC_DEV_REASON_CODE_D
PC_DEV_REGTYPE_D
PC_DEV_REQ_PART_TYPE_D
PC_DEV_SALESREGIMPACT_B
PC_DEV_SALESREGIMPACT_D
PC_DEV_SC_OWNER_B
PC_DEV_SEVFINIMPACT_D
PC_DEV_SIGNOFF_B
PC_DEV_SIGNOFF_DATA
PC_DEV_STOCK_D
PC_DEV_SUPPLIER_B
PC_DEV_TYPE_D
PC_DEV_WIP_D
PC_DEV_WORKFLOW_D
PC_DEV_WORKFLOW_DETAIL_DATA
PC_ECO_CATEGORY_D
PC_ECO_CUM_COMP_FSCL_MONTH_F
PC_ECO_CUM_COMP_FSCL_QTR_F
PC_ECO_CUM_COMP_FSCL_WEEK_F
PC_ECO_CUM_COMP_FSCL_YEAR_F
PC_ECO_CUM_COMPLETED_MONTH_F
PC_ECO_CUM_COMPLETED_QTR_F
PC_ECO_CUM_COMPLETED_WEEK_F
PC_ECO_CUM_COMPLETED_YEAR_F
PC_ECO_CUM_NEW_FSCL_MONTH_F
PC_ECO_CUM_NEW_FSCL_QTR_F
PC_ECO_CUM_NEW_FSCL_WEEK_F
PC_ECO_CUM_NEW_FSCL_YEAR_F
PC_ECO_CUM_NEW_MONTH_F
PC_ECO_CUM_NEW_QTR_F
PC_ECO_CUM_NEW_WEEK_F
PC_ECO_CUM_NEW_YEAR_F
PC_ECO_CUM_REL_FSCL_MONTH_F
PC_ECO_CUM_REL_FSCL_QTR_F
PC_ECO_CUM_REL_FSCL_WEEK_F
PC_ECO_CUM_REL_FSCL_YEAR_F
PC_ECO_CUM_RELEASED_MONTH_F
PC_ECO_CUM_RELEASED_QTR_F
PC_ECO_CUM_RELEASED_WEEK_F
PC_ECO_CUM_RELEASED_YEAR_F
PC_ECO_CUSTOMER_B
PC_ECO_F
PC_ECO_FIELD_D
PC_ECO_FINISHEDGOODS_D
PC_ECO_FUNCTION_D
PC_ECO_ITEM_DATA
PC_ECO_ITEM_PRODUCTLINE_B
PC_ECO_MANUF_OWNER_B
PC_ECO_MFRLOCIMPACT_B
PC_ECO_MFRLOCIMPACT_D
PC_ECO_ONORDER_D
PC_ECO_PRGTASK_B
PC_ECO_PRGTASK_D
PC_ECO_PRIORITY_D
PC_ECO_PRODUCTLINE_B
PC_ECO_PROGRAM_B
PC_ECO_PROGRAM_D
PC_ECO_QUALITY_OWNER_B
PC_ECO_REASON_CODE_D
PC_ECO_REGTYPE_D
PC_ECO_SALESREGIMPACT_B
PC_ECO_SALESREGIMPACT_D
PC_ECO_SC_OWNER_B
PC_ECO_SEVFINIMPACT_D
PC_ECO_SIGNOFF_B
PC_ECO_SIGNOFF_DATA
PC_ECO_STOCK_D
PC_ECO_SUPPLIER_B
PC_ECO_TYPE_D
PC_ECO_WIP_D
PC_ECO_WORKFLOW_D
PC_ECO_WORKFLOW_DETAIL_DATA
PC_ECR_CATEGORY_D
PC_ECR_CUSTOMER_B
PC_ECR_F
PC_ECR_FIELD_D
PC_ECR_FINISHEDGOODS_D
PC_ECR_FUNCTION_D
PC_ECR_IDEA_TYPE_D
PC_ECR_ITEM_DATA
PC_ECR_ITEM_PRODUCTLINE_B
PC_ECR_MANUF_OWNER_B
PC_ECR_MFRLOCIMPACT_B
PC_ECR_MFRLOCIMPACT_D
PC_ECR_ONORDER_D
PC_ECR_PRGTASK_B
PC_ECR_PRGTASK_D
PC_ECR_PRIORITY_D
PC_ECR_PRODUCTLINE_B
PC_ECR_PROGRAM_B
PC_ECR_PROGRAM_D
PC_ECR_QUALITY_OWNER_B
PC_ECR_REASON_CODE_D
PC_ECR_REGTYPE_D
PC_ECR_REQ_PART_TYPE_D
PC_ECR_SALESREGIMPACT_B
PC_ECR_SALESREGIMPACT_D
PC_ECR_SC_OWNER_B
PC_ECR_SEVFINIMPACT_D
PC_ECR_SIGNOFF_B
PC_ECR_SIGNOFF_DATA
PC_ECR_STOCK_D
PC_ECR_SUPPLIER_B
PC_ECR_TYPE_D
PC_ECR_WIP_D
PC_ECR_WORKFLOW_D
PC_ECR_WORKFLOW_DETAIL_DATA
PC_LOCATION_D
PC_MCO_CATEGORY_D
PC_MCO_CUSTOMER_B
PC_MCO_F
PC_MCO_FIELD_D
PC_MCO_FINISHEDGOODS_D
PC_MCO_FUNCTION_D
PC_MCO_ITEM_DATA
PC_MCO_ITEM_PRODUCTLINE_B
PC_MCO_MANUF_OWNER_B
PC_MCO_MFRLOCIMPACT_B
PC_MCO_MFRLOCIMPACT_D
PC_MCO_ONORDER_D
PC_MCO_PRGTASK_B
PC_MCO_PRGTASK_D
PC_MCO_PRIORITY_D
PC_MCO_PRODUCTLINE_B
PC_MCO_PROGRAM_B
PC_MCO_PROGRAM_D
PC_MCO_QUALITY_OWNER_B
PC_MCO_REASON_CODE_D
PC_MCO_REGTYPE_D
PC_MCO_SALESREGIMPACT_B
PC_MCO_SALESREGIMPACT_D
PC_MCO_SC_OWNER_B
PC_MCO_SEVFINIMPACT_D
PC_MCO_SIGNOFF_B
PC_MCO_SIGNOFF_DATA
PC_MCO_STOCK_D
PC_MCO_SUPPLIER_B
PC_MCO_TYPE_D
PC_MCO_WIP_D
PC_MCO_WORKFLOW_D
PC_MCO_WORKFLOW_DETAIL_DATA
PC_PRODUCTLINE_D
PC_SS_CATEGORY_D
PC_SS_CUSTOMER_B
PC_SS_F
PC_SS_FIELD_D
PC_SS_FINISHEDGOODS_D
PC_SS_FUNCTION_D
PC_SS_ITEM_DATA
PC_SS_ITEM_PRODUCTLINE_B
PC_SS_MANUF_OWNER_B
PC_SS_MFRLOCIMPACT_B
PC_SS_MFRLOCIMPACT_D
PC_SS_ONORDER_D
PC_SS_PRGTASK_B
PC_SS_PRGTASK_D
PC_SS_PRIORITY_D
PC_SS_PRODUCTLINE_B
PC_SS_PROGRAM_B
PC_SS_PROGRAM_D
PC_SS_QUALITY_OWNER_B
PC_SS_REASON_CODE_D
PC_SS_REGTYPE_D
PC_SS_SALESREGIMPACT_B
PC_SS_SALESREGIMPACT_D
PC_SS_SC_OWNER_B
PC_SS_SEVFINIMPACT_D
PC_SS_SIGNOFF_B
PC_SS_SIGNOFF_DATA
PC_SS_STOCK_D
PC_SS_SUPPLIER_B
PC_SS_TYPE_D
PC_SS_WIP_D
PC_SS_WORKFLOW_D
PC_SS_WORKFLOW_DETAIL_DATA
PC_SUPPLIER_D
PLM_ACT_STEP_NOTIFIER_B
PLM_ACT_STEP_OWNER_B
PLM_ACT_STEP_SIGNATORY_B
PLM_ACTIVITY_OWNER_B
PLM_ACTIVITY_TPL_OWNER_B
PLM_BASIS_D
PLM_BRAND_D
PLM_BRIDGE_PLP_CTL
PLM_CATEGORY_D
PLM_CHANNEL_D
PLM_DEMOGRAPH_D
PLM_FSCLYR_D
PLM_FUNC_AREA_D
PLM_GATE_SIGNATORY_B
PLM_GLOBAL_CAT_D
PLM_ISP_TITLE_D
PLM_LANG_DATA
PLM_LANG_DATA_UPDATE
PLM_LANG_LOOKUP
PLM_LEAD_CNTRY_D
PLM_METRIC_PHASE_D
PLM_PHASE_FUNC_AREA_B
PLM_PHASE_GATE_KEEPER_B
PLM_PHASE_REVIEWER_B
PLM_PHASE_TEAM_LEADER_B
PLM_PHASE_TEAM_MEM_B
PLM_PRJ_BRAND_B
PLM_PRJ_BUS_UNIT_B
PLM_PRJ_CHANNEL_B
PLM_PRJ_DEMOGRAPH_B
PLM_PRJ_FUNC_AREA_B
PLM_PRJ_GATE_KEEPER_B
PLM_PRJ_GLOBAL_CAT_B
PLM_PRJ_ISP_B
PLM_PRJ_LEAD_CNTRY_B
PLM_PRJ_METRICS_F
PLM_PRJ_REVIEWER_B
PLM_PRJ_STRAT_BRIEF_B
PLM_PRJ_TEAM_LEADER_B
PLM_PRJ_TEAM_MEM_B
PLM_PRJ_TRADE_SPEC_B
PLM_PRJ_TYPE_B
PLM_PRJ_TYPE_D
PLM_PRJ_VISIBILITY_B
PLM_PRJ_VISIBILITY_D
PLM_SPEC_BUS_UNIT_B
PLM_SPEC_BUS_UNIT_D
PLM_SPEC_CLASSIFY_B
PLM_SPEC_CLASSIFY_D
PLM_SPEC_CNTRY_ORIGIN_B
PLM_SPEC_CNTRY_ORIGIN_D
PLM_SPEC_D
PLM_SPEC_F
PLM_SPEC_LANG_B
PLM_SPEC_LANG_D
PLM_SPEC_MAT_TYPE_B
PLM_SPEC_MAT_TYPE_D
PLM_SPEC_MENU_CLASS_B
PLM_SPEC_MENU_CLASS_D
PLM_SPEC_SHIP_COND_B
PLM_SPEC_SHIP_COND_D
PLM_SPEC_SHIP_REQ_B
PLM_SPEC_SHIP_REQ_D
PLM_SPEC_SPCL_ATTR_B
PLM_SPEC_SPCL_ATTR_D
PLM_SPEC_STEP_D
PLM_SPEC_STEP_OWNER_B
PLM_SPEC_STOR_REQ_B
PLM_SPEC_STOR_REQ_D
PLM_SPEC_SUB_RECT_B
PLM_SPEC_SUB_RECT_D
PLM_SPEC_SYS_EQUIVALENT_B
PLM_SPEC_SYS_EQUIVALENT_D
PLM_SPEC_TAXONOMY_D
PLM_SPEC_TYPE_D
PLM_SPEC_WKFLW_F
PLM_STRAT_BRIEF_D
PPM_ACT_DEPACT_B
PPM_ACT_PROGRAMS_B
PPM_ACTIVITY_D
PPM_ACTIVITY_DEL_F
PPM_ACTIVITY_DEL_FS
PPM_ACTIVITY_DOMAINS
PPM_ACTIVITY_F
PPM_ACTIVITY_FS
PPM_ACTIVITY_PLM_REFERENCE_B
PPM_ACTIVITY_WKFLW_D
PPM_BASELINE_D
PPM_BASELINE_F
PPM_BASELINE_MAXREV
PPM_BUS_UNIT_D
PPM_CATEGORY10_B
PPM_CATEGORY10_D
PPM_CATEGORY11_B
PPM_CATEGORY11_D
PPM_CATEGORY12_B
PPM_CATEGORY12_D
PPM_CATEGORY13_B
PPM_CATEGORY13_D
PPM_CATEGORY14_B
PPM_CATEGORY14_D
PPM_CATEGORY15_B
PPM_CATEGORY15_D
PPM_CATEGORY16_B
PPM_CATEGORY16_D
PPM_CATEGORY17_B
PPM_CATEGORY17_D
PPM_CATEGORY18_B
PPM_CATEGORY18_D
PPM_CATEGORY19_B
PPM_CATEGORY19_D
PPM_CATEGORY20_B
PPM_CATEGORY20_D
PPM_CATEGORY21_B
PPM_CATEGORY21_D
PPM_CATEGORY22_B
PPM_CATEGORY22_D
PPM_CATEGORY23_B
PPM_CATEGORY23_D
PPM_CATEGORY24_B
PPM_CATEGORY24_D
PPM_CATEGORY7_B
PPM_CATEGORY7_D
PPM_CATEGORY8_B
PPM_CATEGORY8_D
PPM_CATEGORY9_B
PPM_CATEGORY9_D
PPM_CUSTOMER_B
PPM_CUSTOMER_D
PPM_DEL_TAG_B
PPM_DEL_TAG_D
PPM_DELIVERABLE_D
PPM_DIVISION_B
PPM_DIVISION_D
PPM_FUNC_AREA_B
PPM_FUNC_AREA_D
PPM_GATE_D
PPM_INT_ORGANIZATION_B
PPM_ITEM_B
PPM_LAUNCH_YEAR_B
PPM_LAUNCH_YEAR_D
PPM_LOCATION_B
PPM_LOCATION_D
PPM_PHASE_D
PPM_PHASE_GATE_F
PPM_PHASE_GATE_SIGNOFF_F
PPM_PHASE_WORKFLOW_D
PPM_PORTFOLIO_D
PPM_PORTFOLIO_F
PPM_PRD_DEMAND_F
PPM_PRD_INV_QTY_F
PPM_PRD_INV_VALUE_F
PPM_PRD_REVENUE_F
PPM_PRD_UNIT_REC_F
PPM_PRD_UNIT_SHIP_F
PPM_PRJ_COST_F
PPM_PRJ_DET_SIGNOFF_F
PPM_PRJ_DET_WKFLW_F
PPM_PRJ_FORE_REV_F
PPM_PRJ_PH_MET_FLG
PPM_PRJ_SUM_F
PPM_PRODUCT_LINE_B
PPM_PRODUCT_LINE_D
PPM_PROGRAM_D
PPM_PROGRAM_F
PPM_PROJECT_D
PPM_PROJECT_PORTFOLIO_B
PPM_PROJECT_PROGRAM_B
PPM_PROJECT_TYPE_B
PPM_PROJECT_TYPE_D
PPM_PROJECT_WORKFLOW_D
PPM_REGION_B
PPM_REGION_D
PPM_ROOT_PROGRAM_D
PPM_SNAPSHOT_F
PQM_AUDIT_CATEGORY_D
PQM_AUDIT_CUSTOMER_B
PQM_AUDIT_DEPARTMENT_D
PQM_AUDIT_DOC_AUDITED_B
PQM_AUDIT_DOC_AUDITED_D
PQM_AUDIT_EXTRNL_AGENCY_D
PQM_AUDIT_F
PQM_AUDIT_FINDING_TYPE_B
PQM_AUDIT_FINDING_TYPE_D
PQM_AUDIT_FORM_D
PQM_AUDIT_ITEM_DATA
PQM_AUDIT_ITEM_PRODUCTLINE_B
PQM_AUDIT_LOCATION_D
PQM_AUDIT_MANUAL_SECTION_D
PQM_AUDIT_PRD_AUDITED_B
PQM_AUDIT_PRD_AUDITED_D
PQM_AUDIT_PRG_B
PQM_AUDIT_PRG_D
PQM_AUDIT_PRIORITY_D
PQM_AUDIT_PROCESS_AUDITED_B
PQM_AUDIT_PROCESS_AUDITED_D
PQM_AUDIT_PRODUCTLINE_B
PQM_AUDIT_RESULT_D
PQM_AUDIT_STANDARD_D
PQM_AUDIT_SUPPLIER_B
PQM_AUDIT_TYPE_D
PQM_AUDIT_WORKFLOW_D
PQM_AUDIT_WORKFLOW_DETAIL_DATA
PQM_CAPA_BUSINESS_RISK_D
PQM_CAPA_CATEGORY_D
PQM_CAPA_CORRECTIVE_ACTION_D
PQM_CAPA_CUSTOMER_B
PQM_CAPA_F
PQM_CAPA_FUNCTION_B
PQM_CAPA_FUNCTION_D
PQM_CAPA_ITEM_DATA
PQM_CAPA_ITEM_PRODUCTLINE_B
PQM_CAPA_LOCATION_D
PQM_CAPA_PRBL_SOL_METHOD_D
PQM_CAPA_PREVENTIVE_ACTION_D
PQM_CAPA_PRIORITY_D
PQM_CAPA_PRODUCTLINE_B
PQM_CAPA_QMS_SECTION_B
PQM_CAPA_QMS_SECTION_D
PQM_CAPA_QMS_STANDARD_B
PQM_CAPA_QMS_STANDARD_D
PQM_CAPA_REG_RISK_D
PQM_CAPA_ROOT_CAUSE_D
PQM_CAPA_SUPPLIER_B
PQM_CAPA_TEAM_B
PQM_CAPA_TEAM_D
PQM_CAPA_TYPE_D
PQM_CAPA_WORKFLOW_D
PQM_CAPA_WORKFLOW_DETAIL_DATA
PQM_LOCATION_D
PQM_NCR_CATEGORY_D
PQM_NCR_CAUSE_D
PQM_NCR_CUSTOMER_B
PQM_NCR_DOC_B
PQM_NCR_DOC_D
PQM_NCR_F
PQM_NCR_FUNC_AREA_B
PQM_NCR_FUNC_AREA_D
PQM_NCR_INSPECTION_TYPE_D
PQM_NCR_ITEM_DATA
PQM_NCR_ITEM_PRODUCTLINE_B
PQM_NCR_MTRL_REVIEW_D
PQM_NCR_PRG_TASK_B
PQM_NCR_PRG_TASK_D
PQM_NCR_PRIORITY_D
PQM_NCR_PROBLEM_TYPE_D
PQM_NCR_PRODUCTLINE_B
PQM_NCR_PROGRAM_RELEASE_D
PQM_NCR_QMS_B
PQM_NCR_QMS_D
PQM_NCR_QMS_SECTION_D
PQM_NCR_REASON_CODE_D
PQM_NCR_RESOLUTION_D
PQM_NCR_RPT_FAILURE_TYPE_D
PQM_NCR_SEVERITY_D
PQM_NCR_SOURCE_D
PQM_NCR_SUPPLIER_B
PQM_NCR_SUSP_FAILURE_TYPE_D
PQM_NCR_TYPE_D
PQM_NCR_WORKFLOW_D
PQM_NCR_WORKFLOW_DETAIL_DATA
PQM_PR_CALLER_TYPE_D
PQM_PR_CATEGORY_D
PQM_PR_CONTACT_MODE_D
PQM_PR_CUSTOMER_B
PQM_PR_DESIGN_OWNER_B
PQM_PR_DOC_B
PQM_PR_DOC_D
PQM_PR_F
PQM_PR_FUNC_AREA_B
PQM_PR_FUNC_AREA_D
PQM_PR_ITEM_DATA
PQM_PR_ITEM_FAIL_CAUSE_1_B
PQM_PR_ITEM_FAIL_CAUSE_1_D
PQM_PR_ITEM_FAIL_CAUSE_2_B
PQM_PR_ITEM_FAIL_CAUSE_2_D
PQM_PR_ITEM_FAIL_CAUSE_3_B
PQM_PR_ITEM_FAIL_CAUSE_3_D
PQM_PR_ITEM_FAIL_MFR_PART_D
PQM_PR_ITEM_FAILURE_TYPE_B
PQM_PR_ITEM_FAILURE_TYPE_D
PQM_PR_ITEM_PRODUCTLINE_B
PQM_PR_ITEM_RPT_FAILURE_D
PQM_PR_ITEM_TLA_D
PQM_PR_PRBL_REPD_D
PQM_PR_PRG_D
PQM_PR_PRG_TASK_B
PQM_PR_PRG_TASK_D
PQM_PR_PRIORITY_D
PQM_PR_PROBLEM_TYPE_D
PQM_PR_PRODUCTLINE_B
PQM_PR_QMS_B
PQM_PR_QMS_D
PQM_PR_REASON_CODE_D
PQM_PR_REG_RPT_TYPE_D
PQM_PR_RESOLUTION_D
PQM_PR_RPT_FAILURE_TYPE_D
PQM_PR_SALES_REGION_D
PQM_PR_SEVERITY_D
PQM_PR_SUPPLIER_B
PQM_PR_SUSP_FAILURE_TYPE_D
PQM_PR_TYPE_D
PQM_PR_WORKFLOW_D
PQM_PR_WORKFLOW_DETAIL_DATA
PQM_PRODUCTLINE_D
REVISION_CHANGE_TYPE_D
SITE_D
SUPPLIER_D
USER_D
USER_PRODUCTLINE_B
USER_SIGNOFF_TYPE_D
USER_USER_GROUP_B
W_DAY_D
W_FSCL_MONTH_D
W_FSCL_QTR_D
W_FSCL_WEEK_D
W_FSCL_YEAR_D
W_LOCALIZED_STRING_G
W_LOCALIZED_STRING_GS
W_MONTH_D
W_QTR_D
W_WEEK_D
W_YEAR_D