http://www.oracleappsquery.com/?

q=oracle-apps-R12-PO-Purchasing-tables-views

Oracle Purchasing Tables:

TABLE NAME
CHV_AUTHORIZATIONS_GT
EDW_PO_VENDOR_HIERARCHIES

FND_FUNCTION_PARAMETER_MAP

FND_NOTIFICATIONS
PO_ACCEPTANCES
PO_ACCRUAL_ACCOUNTS_TEMP_ALL
PO_ACCRUAL_RECONCILE_TEMP_ALL
PO_ACCRUAL_WRITE_OFFS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL_EFC
PO_ACTION_HISTORY
PO_AGENTS
PO_APPROVAL_LIST_HEADERS
PO_APPROVAL_LIST_LINES
PO_APPROVED_SUPPLIER_LIST

PO_APPROVED_SUPPLIER_LIST_GT

PO_ASL_API_ERRORS
PO_ASL_ATTRIBUTES
PO_ASL_ATTRIBUTES_GT
PO_ASL_DOCUMENTS
PO_ASL_DOCUMENTS_GT
PO_ASL_STATUS_RULES
PO_ASL_STATUSES
PO_ATT_TMP_RECORDS
PO_ATTR_VALUES_ARCHIVE
PO_ATTR_VALUES_INTERFACE
PO_ATTR_VALUES_TLP_ARCHIVE
PO_ATTR_VALUES_TLP_INTERFACE
PO_ATTRIBUTE_VALUES
PO_ATTRIBUTE_VALUES_DRAFT

PO_ATTRIBUTE_VALUES_TLP

PO_ATTRIBUTE_VALUES_TLP_DRAFT
PO_AUTOCREATE_UDA_RULES
PO_AUTOSOURCE_DOCUMENTS_ALL
PO_AUTOSOURCE_RULES
PO_AUTOSOURCE_VENDORS

PO_BC_DISTRIBUTIONS
PO_CHANGE_ORDER_TOLERANCES_ALL

PO_CHANGE_REQUESTS

PO_CLM_AGENCIES
PO_CLM_ASSGNMT_ACTION_HISTORY
PO_CLM_ASSGNMT_MILESTONE_DTLS
PO_CLM_ASSIGNMENTS
PO_CLM_CAR_LOGS
PO_CLM_CARS
PO_CLM_MILESTONE_TEMPLATES
PO_CLM_MILESTONES
PO_CLM_MIPR_ACTION_HISTORY
PO_CLM_TO_FPDS_AWARD_TYP_MAP
PO_CLOSEOUT_DETAILS
PO_COMMODITIES_B
PO_COMMODITIES_TL
PO_COMMODITY_CATEGORIES
PO_COMMODITY_GRANTS
PO_CONTROL_FUNCTIONS
PO_CONTROL_GROUPS_ALL
PO_CONTROL_RULES
PO_CONTROL_RULES_EFC
PO_CWK_ASSOCIATIONS
PO_DIFF_CONFIG
PO_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL_EBS
PO_DISTRIBUTIONS_ALL_EXT_B
PO_DISTRIBUTIONS_ALL_EXT_TL
PO_DISTRIBUTIONS_ARCHIVE_ALL
PO_DISTRIBUTIONS_DRAFT_ALL

PO_DISTRIBUTIONS_GT

PO_DISTRIBUTIONS_GT1

PO_DISTRIBUTIONS_GT2
PO_DISTRIBUTIONS_INTERFACE

PO_DOC_STYLE_HEADERS

PO_DOC_STYLE_LINES_B

PO_DOC_STYLE_LINES_TL

PO_DOC_STYLE_VALUES
PO_DOCUMENT_TOTALS_GT
PO_DOCUMENT_TYPES_ALL_B
PO_DOCUMENT_TYPES_ALL_TL
PO_DRAFTS
PO_EDA_ENTITY_DIFFERENCES
PO_EDA_MAPPING
PO_EDA_UDA_ATTR_VALUES
PO_ELECTRONIC_DATA_ACCESS
PO_EMPLOYEE_HIERARCHIES_ALL
PO_ENCUMBRANCE_GT
PO_ENCUMBRANCE_GT1
PO_ENTITY_DIFFERENCES
PO_ENTITY_GT
PO_ENTITY_LOCKS
PO_ENTITY_ROLLUP_GT
PO_EXHIBIT_DETAILS
PO_EXHIBIT_DETAILS_ARCHIVE
PO_EXHIBIT_DETAILS_DRAFT
PO_GA_ORG_ASSIGN_DRAFT
PO_GA_ORG_ASSIGNMENTS
PO_GA_ORG_ASSIGNMENTS_ARCHIVE
PO_HAZARD_CLASSES_B
PO_HAZARD_CLASSES_TL

PO_HEADERS_ALL

PO_HEADERS_ALL_EBS
PO_HEADERS_ALL_EXT_B

PO_HEADERS_ALL_EXT_B_ARCHIVE

PO_HEADERS_ALL_EXT_TL

PO_HEADERS_ALL_EXT_TL_ARCHIVE

PO_HEADERS_ARCHIVE_ALL

PO_HEADERS_DRAFT_ALL

PO_HEADERS_GT

PO_HEADERS_GT1

PO_HEADERS_INTERFACE
PO_HISTORY_POS_ALL
PO_HISTORY_RECEIPTS
PO_HISTORY_REQUISITIONS_ALL
PO_HISTORY_VENDORS
PO_INTERFACE_ERRORS
PO_JOB_ASSOCIATIONS_B
PO_JOB_ASSOCIATIONS_TL

PO_LINE_LOC_ALL_EXT_B_ARCHIVE

PO_LINE_LOC_ALL_EXT_TL_ARCHIVE

PO_LINE_LOCATIONS_ALL

PO_LINE_LOCATIONS_ALL_EBS

PO_LINE_LOCATIONS_ALL_EXT_B

PO_LINE_LOCATIONS_ALL_EXT_TL

PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_LINE_LOCATIONS_DRAFT_ALL

PO_LINE_LOCATIONS_GT

PO_LINE_LOCATIONS_GT1

PO_LINE_LOCATIONS_INTERFACE
PO_LINE_TYPES_B
PO_LINE_TYPES_TL
PO_LINE_UCAS

PO_LINES_ALL

PO_LINES_ALL_EBS

PO_LINES_ALL_EXT_B

PO_LINES_ALL_EXT_B_ARCHIVE

PO_LINES_ALL_EXT_TL

PO_LINES_ALL_EXT_TL_ARCHIVE

PO_LINES_ARCHIVE_ALL

PO_LINES_DRAFT_ALL

PO_LINES_GT

PO_LINES_GT1

PO_LINES_INTERFACE
PO_LOCATION_ASSOCIATIONS
PO_LOCATION_ASSOCIATIONS_ALL
PO_MASSCANCEL_INCLUDES_ALL
PO_MASSCANCEL_INTERIM
PO_MC_DISTRIBUTIONS
PO_MC_HEADERS

PO_MULTI_MOD_CHANGES

PO_MULTI_MOD_CLAUSE_CHANGES

PO_MULTI_MOD_DOCS

PO_MULTI_MOD_REQUESTS

PO_MULTI_MOD_VAL_RESULTS

PO_NOTE_ATTRIBUTES
PO_NOTE_REFERENCES
PO_NOTES
PO_NOTIFICATION_CONTROLS
PO_NOTIFICATION_CTRL_DRAFT
PO_NOTIFICATIONS_ALL
PO_OKC_VARS_GT
PO_ONLINE_REPORT_TEXT
PO_POSITION_CONTROLS_ALL
PO_PRICE_ADJ_ATTRIBS
PO_PRICE_ADJ_ATTRIBS_ARCHIVE
PO_PRICE_ADJ_ATTRIBS_DRAFT
PO_PRICE_ADJUSTMENTS
PO_PRICE_ADJUSTMENTS_ARCHIVE
PO_PRICE_ADJUSTMENTS_DRAFT
PO_PRICE_DIFF_DRAFT
PO_PRICE_DIFF_INTERFACE
PO_PRICE_DIFFERENTIALS
PO_PRICE_DIFFERENTIALS_ARCHIVE
PO_PRINT_FORM_FORMATS
PO_PROTESTS
PO_PURGE_PO_LIST
PO_PURGE_RECEIPT_LIST
PO_PURGE_REQ_LIST
PO_PURGE_VENDOR_LIST
PO_QUALITY_CODES
PO_QUOTATION_APPROVALS_ALL
PO_RCV_CHARGE_ALLOCATIONS
PO_RCV_CHARGES
PO_RELATED_TEMPLATES
PO_RELEASES_ALL
PO_RELEASES_ALL_EBS
PO_RELEASES_ARCHIVE_ALL
PO_REQ_DIST_INTERFACE_ALL
PO_REQ_DISTRIBUTIONS_ALL
PO_REQ_DISTRIBUTIONS_ALL_EFC
PO_REQ_DISTRIBUTIONS_EXT_B
PO_REQ_DISTRIBUTIONS_EXT_TL
PO_REQ_HEADERS_EXT_B
PO_REQ_HEADERS_EXT_TL
PO_REQ_LINES_EXT_B
PO_REQ_LINES_EXT_TL

PO_REQ_LINES_GT

PO_REQEXPRESS_HEADERS_ALL
PO_REQEXPRESS_LINES_ALL
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQUISITION_LINES_ALL_EFC
PO_REQUISITION_SUPPLIERS
PO_REQUISITIONS_INT_ALL_EFC
PO_REQUISITIONS_INTERFACE_ALL
PO_RESCHEDULE_INTERFACE
PO_RETRIEVED_TIMECARDS

PO_RETROPRICE_GT

PO_RFQ_VENDORS
PO_RULE_EXPENSE_ACCOUNTS
PO_SUPPLIER_ITEM_CAPACITY
PO_SUPPLIER_ITEM_CAPACITY_GT
PO_SUPPLIER_ITEM_TOLERANCE

PO_SUPPLIER_ITEM_TOLERANCE_GT

PO_SYSTEM_PARAMETERS_ALL
PO_UDA_AG_TEMPLATE_USAGES
PO_UDA_AG_TEMPLATES
PO_UDA_AG_TEMPLATES_TL
PO_UDA_DUMMY_ALL
PO_UDA_DUMMY_ALL_EXT_B
PO_UDA_DUMMY_ALL_EXT_TL
PO_UDA_INTERFACE
PO_UDA_MAPPINGS
PO_UN_NUMBERS_B
PO_UN_NUMBERS_TL
PO_UNIQUE_IDENTIFIER_CONT_ALL
PO_USAGE_ATTRIBUTES
PO_USAGES
PO_USER_PREFERENCES
PO_USER_WARRANTS
PO_VALIDATION_RESULTS_GT
PO_VENDOR_CONTACTS
PO_VENDOR_CONTACTS_OBS
PO_VENDOR_ELIGIBILITY
PO_VENDOR_ELIGIBILITY_H
PO_VENDOR_LIST_ENTRIES
PO_VENDOR_LIST_HEADERS
PO_VENDOR_SITES_ALL
PO_VENDOR_SITES_ALL_EBS
PO_VENDOR_SITES_OBS
PO_VENDORS
PO_VENDORS_EBS
PO_VENDORS_OBS
PO_WAGE_DETERMINATION
PO_WARRANT_LINES

PO_WF_CANDIDATE_REQ_LINES_TEMP

PO_WF_DEBUG
PO_WF_USER_TMP
POA_BIS_SAVINGS
POA_BIS_SAVINGS_EFC
POA_BIS_SAVINGS_RPT
POA_BIS_SAVINGS_RPT_EFC
POA_BIS_SUPPLIER_PERFORMAN_EFC
POA_BIS_SUPPLIER_PERFORMANCE
POA_CM_DISTRIBUTIONS
POA_CM_EVAL_SCORES
POA_CM_EVALUATION
PON_AUCTION_HEADERS_EXT_B
PON_AUCTION_HEADERS_EXT_TL
PON_AUCTION_ITEM_PRICES_EXT_B
PON_AUCTION_ITEM_PRICES_EXT_TL
PON_BID_HEADERS_EXT_B
PON_BID_HEADERS_EXT_TL

PON_BID_ITEM_PRICES_EXT_B

PON_BID_ITEM_PRICES_EXT_TL
 RCV_ACCOUNTING_EVENT_TYPES
RCV_ACCOUNTING_EVENTS
RCV_CHARGES_INTERFACE
RCV_FTE_TRANSACTION_LINES
RCV_GAPLESS_INVOICE_NUMBERS

RCV_HEADERS_INTERFACE

RCV_LOT_TRANSACTIONS
RCV_LOTS_INTERFACE
RCV_LOTS_SUPPLY
RCV_MC_REC_SUB_LEDGER
RCV_MC_SHIPMENT_HEADERS
RCV_MC_SHIPMENT_LINES
RCV_MC_SUB_LEDGER_DETAILS
RCV_MC_TRANSACTIONS
RCV_PARAMETERS
RCV_RECEIVING_SUB_LEDGER
RCV_ROUTING_HEADERS
RCV_ROUTING_HEADERS_OLD
RCV_ROUTING_STEPS
RCV_SERIAL_TRANSACTIONS
RCV_SERIALS_INTERFACE
RCV_SERIALS_SUPPLY
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_SHIPMENT_LINES_EFC
RCV_STAGING_TABLE
RCV_SUB_LEDGER_DETAILS
RCV_SUPPLY
RCV_TRANSACTIONS
RCV_TRANSACTIONS_INTERFACE
RCV_UPGRADE_STEPS

Oracle Purchasing Views:

VIEW NAME
EDWBV_TPRT_P1_TPARTNER_LCV
EDWBV_TPRT_P2_TPARTNER_LCV
EDWBV_TPRT_P3_TPARTNER_LCV
EDWBV_TPRT_P4_TPARTNER_LCV
EDWBV_TPRT_TPARTNER_LOC_LCV
EDWBV_TPRT_TRADE_PARTNER_LCV
EDW_GEOGRAPHY_MPV
EDW_GEOG_AREA1_LCV
EDW_GEOG_AREA2_LCV
EDW_GEOG_CITY_LCV
EDW_GEOG_COUNTRY_LCV
EDW_GEOG_LOCATION_LCV
EDW_GEOG_POSTCODE_CITY_LCV
EDW_GEOG_POSTCODE_LCV
EDW_GEOG_REGION_LCV
EDW_GEOG_STATE_LCV
EDW_GEOG_STATE_REGION_LCV
EDW_LOOKUP_CODES_LCV
EDW_LOOKUP_CODE_FKV
EDW_LOOKUP_MPV
EDW_POA_LN_TYPE_LCV
EDW_POA_LN_TYPE_MPV
EDW_POA_SPIM_SPLRITEM_FKV
EDW_POA_SPIM_SPLRITEM_LCV
EDW_POA_SPLRITEM_MPV
EDW_PO_VENDOR_HIERARCHIES_V
EDW_TPRT_P0_TPARTNER_LCV
EDW_TPRT_P1_TPARTNER_LCV
EDW_TPRT_P2_TPARTNER_LCV
EDW_TPRT_P3_TPARTNER_LCV
EDW_TPRT_P4_TPARTNER_LCV
EDW_TPRT_TPARTNER_LOC_LCV
EDW_TPRT_TRADE_PARTNER_LCV
EDW_TRD_PARTNER_CUST_FKV
EDW_TRD_PARTNER_MPV
EDW_TRD_PARTNER_SUPP_FKV
FND_NOTIFICATIONS_V
GL_USSGL_TRANSACTION_CODES_V
HR_EMPLOYEES
HR_EMPLOYEES_ALL_V
HR_EMPLOYEES_CURRENT_V
ORG_FREIGHT_CODE_VAL_V
PER_POSITION_STRUCTURES_ALL_V
POABV_EDW_AGREEMENT_LINES_FCV
POABV_EDW_CONTRACT_AGRMNTS_FCV
POABV_EDW_PO_DISTRIBUTIONS_FCV
POABV_EDW_RECEIVING_TXN_FCV
POABV_EDW_SUPPLIER_PERFORM_FCV
POA_BIS_PPS_OPERU_LOV_V
POA_BIS_SAVINGS_BUYER_LOV_V
POA_BIS_SAVINGS_COMM_LOV_V
POA_BIS_SAVINGS_OPERU_LOV_V
POA_BIS_SAVINGS_ORG_LOV_V
POA_BIS_SAVINGS_RPT_V
POA_BIS_SAVINGS_SUPPLIER_LOV_V

POA_BIS_SAVINGS_V

POA_BIS_SUPPERF_CONSUPP_LOV_V
POA_BIS_SUPPERF_ITEM_LOV_V
POA_BIS_SUPPERF_PRESUPP_LOV_V

POA_BIS_SUPPLIER_PERFORMANCE_V

POA_CM_COMMODITY_LOV_V
POA_CM_EVALUATED_BY_LOV_V
POA_CM_ITEM_LOV_V
POA_CM_OPER_UNIT_LOV_V
POA_CM_PERIOD_NAME_LOV_V
POA_CM_PERIOD_TYPE_LOV_V
POA_CM_SITE_LOV_V
POA_CM_SUPPLIER_LOV_V
POA_CM_VIEW2_V
POA_CM_VIEW_V
POA_CUSTOM_MEASURE_LOV_V
POA_EDW_AGREEMENT_LINES_FCV
POA_EDW_CONTRACT_AGRMNTS_FCV
POA_EDW_CUSTOM_MEASURE_FCV
POA_EDW_PO_DISTRIBUTIONS_FCV
POA_EDW_RECEIVING_TXN_FCV
POA_EDW_SUPPLIER_PERFORM_FCV
POA_PURCHASE_SALES_V
POBV_APPROVED_SUPPLIER_LISTS
POBV_ASL_DOCUMENTS
POBV_BKT_PO_DISTRIBUTIONS
POBV_BKT_PO_LINES
POBV_BKT_PO_LINE_PRICE_BREAKS
POBV_BKT_PO_RELEASES
POBV_BKT_PO_SHIPMENTS
POBV_BKT_PURCHASE_ORDERS
POBV_BUYERS
POBV_HAZARD_CLASSES
POBV_INBOUND_SHIPMENTS
POBV_INBOUND_SHIPMENT_LINES
POBV_MC_INBOUND_SHIPMENTS
POBV_MC_PO_DISTRIBUTIONS
POBV_MC_PURCHASE_ORDERS
POBV_MC_RECEIVING_SUBLEDGERS
POBV_MC_RECEIVING_TRANSACTIONS
POBV_PLAN_PO_DISTRIBUTIONS
POBV_PLAN_PO_LINES
POBV_PLAN_PO_LINE_SHIPMENTS
POBV_PLAN_PO_RELEASES
POBV_PLAN_PURCHASE_ORDERS
POBV_PO_DISTRIBUTIONS
POBV_PO_LINES
POBV_PO_LINE_SHIPMENTS
POBV_PURCHASE_CONTRACTS
POBV_PURCHASE_ORDERS
POBV_QUOTATIONS
POBV_QUOTATION_LINES
POBV_QUOTATION_PRICE_BREAKS
POBV_QUOTATION_SHIPMENTS
POBV_RECEIVING_ROUTINGS
POBV_RECEIVING_SUBLEDGERS
POBV_RECEIVING_TRANSACTIONS
POBV_REQUESTS_FOR_QUOTATION
POBV_REQUISITIONS
POBV_REQUISITION_DISTRIBUTIONS
POBV_REQUISITION_LINES
POBV_RFQ_LINES
POBV_RFQ_PRICE_BREAKS
POBV_RFQ_SHIPMENTS
POBV_RFQ_SUPPLIERS
POBV_RFQ_SUPPLIER_LISTS
POBV_RFQ_SUPPLIER_LIST_ENTRIES
POBV_SCHEDULED_DISTRIBUTIONS
POBV_SCHEDULED_SHIPMENTS
POBV_STD_PO_DISTRIBUTIONS
POBV_STD_PO_LINES
POBV_STD_PO_LINE_SHIPMENTS
POBV_STD_PURCHASE_ORDERS
POBV_SUPPLIERS
POBV_SUPPLIER_CONTACTS
POBV_SUPPLIER_SITES
POBV_UN_NUMBERS
POFV_APPROVED_SUPPLIER_LISTS
POFV_ASL_DOCUMENTS
POFV_BKT_PO_DISTRIBUTIONS
POFV_BKT_PO_LINES
POFV_BKT_PO_LINE_PRICE_BREAKS
POFV_BKT_PO_RELEASES
POFV_BKT_PO_SHIPMENTS
POFV_BKT_PURCHASE_ORDERS
POFV_BUYERS
POFV_HAZARD_CLASSES
POFV_INBOUND_SHIPMENTS
POFV_INBOUND_SHIPMENT_LINES
POFV_MC_INBOUND_SHIPMENTS
POFV_MC_PO_DISTRIBUTIONS
POFV_MC_PURCHASE_ORDERS
POFV_MC_RECEIVING_SUBLEDGERS
POFV_MC_RECEIVING_TRANSACTIONS
POFV_PLAN_PO_DISTRIBUTIONS
POFV_PLAN_PO_LINES
POFV_PLAN_PO_LINE_SHIPMENTS
POFV_PLAN_PO_RELEASES
POFV_PLAN_PURCHASE_ORDERS
POFV_PO_DISTRIBUTIONS
POFV_PO_LINES
POFV_PO_LINE_SHIPMENTS
POFV_PURCHASE_CONTRACTS
POFV_PURCHASE_ORDERS
POFV_QUOTATIONS
POFV_QUOTATION_LINES
POFV_QUOTATION_PRICE_BREAKS
POFV_QUOTATION_SHIPMENTS
POFV_RECEIVING_ROUTINGS
POFV_RECEIVING_SUBLEDGERS
POFV_RECEIVING_TRANSACTIONS
POFV_REQUESTS_FOR_QUOTATION
POFV_REQUISITIONS
POFV_REQUISITION_DISTRIBUTIONS
POFV_REQUISITION_LINES
POFV_RFQ_LINES
POFV_RFQ_PRICE_BREAKS
POFV_RFQ_SHIPMENTS
POFV_RFQ_SUPPLIERS
POFV_RFQ_SUPPLIER_LISTS
POFV_RFQ_SUPPLIER_LIST_ENTRIES
POFV_SCHEDULED_DISTRIBUTIONS
POFV_SCHEDULED_SHIPMENTS
POFV_STD_PO_DISTRIBUTIONS
POFV_STD_PO_LINES
POFV_STD_PO_LINE_SHIPMENTS
POFV_STD_PURCHASE_ORDERS
POFV_SUPPLIERS
POFV_SUPPLIER_CONTACTS
POFV_SUPPLIER_SITES
POFV_UN_NUMBERS
PON_AUCTION_HEADERS_EXT_VL
PON_AUCTION_ITEM_PRICES_EXT_VL
PON_BID_HEADERS_EXT_VL
PON_BID_ITEM_PRICES_EXT_VL
POS_AP_CHECKS_V
POS_AP_EXPENSE_REPORTS_V
POS_AP_INVOICES_V
POS_AP_INVOICE_PAYMENTS_V
POS_CHV_AUTHORIZATIONS_V
POS_CHV_ITEM_ORDERS_V
POS_CHV_SCHEDULE_HEADERS_V
POS_CHV_SCHEDULE_ITEMS_V
POS_DISTRIBUTIONS_V
POS_HEADERS_V
POS_HORIZONTAL_SCHEDULE_V
POS_LINES_V
POS_MTL_ONHAND_ITEMS_DMMY_V
POS_MTL_ONHAND_ITEMS_KFV
POS_MTL_ONHAND_LOCATOR_KFV
POS_MTL_ONHAND_LOT_KFV
POS_MTL_ONHAND_REV_KFV
POS_MTL_ONHAND_SERIAL_KFV
POS_MTL_ONHAND_SUB_KFV
POS_ORD_MODIFIERS_V
POS_ORG_ADDRESS_V
POS_PER_PEOPLE_X_V
POS_PO_DETAILS_V
POS_PO_EMPLOYEE_DETAILS_V
POS_PO_EXPECTED_RECEIPTS_V
POS_PO_HEADERS_ARCHIVE_V
POS_PO_INVOICE_SUP_ORDERS_V
POS_PO_LATE_RECEIPTS_V
POS_PO_LINES_ARCHIVE_V
POS_PO_LINES_V
POS_PO_LIST_USERS_V
POS_PO_LOCATION_DETAIL_V
POS_PO_OSP_V
POS_PO_QA_SHIPMENTS_V
POS_PO_REVISIONS_HEADER_V
POS_PO_REVISIONS_LINE_V
POS_PO_REVISIONS_TEMP_V
POS_PO_RFQ_HEADERS_V
POS_PO_RFQ_LINES_V
POS_PO_SUMMARY_V
POS_PO_SUPPLIER_AGREEMENTS_V
POS_PO_SUPPLIER_INFO_V
POS_PO_SUPPLIER_ITEMS_V
POS_PO_SUPPLIER_ORDERS_V
POS_PO_SUP_ORDER_INVOICES_V
POS_PO_USER_DETAILS_V
POS_PO_VENDORS_V
POS_RCV_EARLY_LATE_RECEIPTS_V
POS_RCV_REJECTED_ITEMS_V
POS_RCV_RETURNS_V
POS_RCV_TRANSACTIONS_V
POS_RECEIPT_HEADERS_V
POS_SHIPMENTS_V
POS_VIEW_ASN
PO_832_BATCH_ID_V
PO_ACCEPTANCES_V
PO_ACCRUAL_RECONCILE_TEMP
PO_ACTION_HISTORY_V
PO_ACT_HIST_V
PO_AGENTS_NAME_V
PO_AGENTS_V
PO_ALERT_BLANKET_VIEW
PO_ALERT_CONTRACT_VIEW
PO_ALERT_CONTRACT_VIEW2
PO_ALERT_PLANNED_VIEW
PO_ALERT_SCHEDULED_VIEW

PO_ALL_DOC_STYLE_LINES

PO_APPROVED_SUPPLIER_LIST_V
PO_APPROVED_SUPPLIER_LIS_VAL_V
PO_AP_RECEIPT_MATCH_V

PO_AP_RETROACTIVE_DIST_V
PO_ASL_ATTRIBUTES_V
PO_ASL_ATTRIBUTES_VAL_V
PO_ASL_DOCUMENTS_V
PO_ASL_ITEMS_V
PO_ASL_STATUS_RULES_V
PO_ASL_SUPPLIERS_V
PO_ATTR_VALUES_MERGE_V
PO_ATTR_VALUES_TLP_MERGE_V
PO_AUTOSOURCE_DOCUMENTS_V
PO_AUTOSOURCE_RULES_ALL
PO_AUTOSOURCE_RULES_V
PO_AUTOSOURCE_VENDORS_ALL
PO_BUYERS_ALL_V
PO_BUYERS_VAL_V
PO_BUYER_NAME_NUM_V
PO_BY_BUYER_V
PO_CATALOG_QUOTES_ALL_V
PO_CLM_OPERATING_UNITS
PO_COMMODITIES_VL
PO_CONTRACTS_VAL_V
PO_CXML_DELIVERTO_ARCH_V
PO_CXML_HEADER_ARCH_V
PO_CXML_LINE_LOC_ARCH_V
PO_DESTINATION_TYPES_ALL_V
PO_DESTINATION_TYPES_VAL_V
PO_DISTINCT_RELID_LINEID_V
PO_DISTRIBUTIONS_ALL_EXT_VL
PO_DISTRIBUTIONS_ALL_MRC_V
PO_DISTRIBUTIONS_AP2_V
PO_DISTRIBUTIONS_AP_V
PO_DISTRIBUTIONS_INQ_V

PO_DISTRIBUTIONS_MERGE_V

PO_DISTRIBUTIONS_MRC_V
PO_DISTRIBUTIONS_PRINT
PO_DISTRIBUTIONS_TRX_V
PO_DISTRIBUTIONS_V
PO_DISTRIBUTION_ARCHIVE_XML
PO_DISTRIBUTION_XML

PO_DOCUMENT_HEADERS_VIEW

PO_DOCUMENT_TYPES_ALL_VL
PO_DOCUMENT_TYPES_V
PO_DOCUMENT_TYPES_VL
PO_DOCUMENT_VERSIONS_V

PO_DOC_STYLE_LINES_VL

PO_ECX_ATTACHMENTS_V
PO_ECX_DISTRBN_ARCH_V
PO_ECX_HEADER_ARCH_V
PO_ECX_HEADER_V
PO_ECX_LINE_ARCH_V
PO_ECX_LINE_LOC_ARCH_V
PO_ECX_LINE_LOC_V
PO_ECX_LINE_V
PO_EDA_CLM_DOC_NBR_V
PO_EMPLOYEE_HIERARCHIES
PO_EMPLOYEE_HIERARCHIES_ALL_V
PO_ENC_AEL_GL_V
PO_FOB_VAL_V
PO_FREIGHT_TERMS_VAL_V
PO_GA_ORG_ASSIGNMENTS_V
PO_GA_ORG_ASSIGN_MERGE_V
PO_HAZARD_CLASSES_ALL_V
PO_HAZARD_CLASSES_VAL_V
PO_HAZARD_CLASSES_VL
PO_HEADERS_ALL_EXT_VL
PO_HEADERS_ALL_MRC_V
PO_HEADERS_AP_V
PO_HEADERS_ARCHIVE_XML
PO_HEADERS_CHANGE_PRINT
PO_HEADERS_INQ_PO_V
PO_HEADERS_INQ_REL_V
PO_HEADERS_INQ_V
PO_HEADERS_MERGE_V
PO_HEADERS_MRC_V
PO_HEADERS_PRINT
PO_HEADERS_RFQQT_V
PO_HEADERS_TRX_V
PO_HEADERS_V
PO_HEADERS_VIEW
PO_HEADERS_XML
PO_HEADER_RELEASE_V
PO_HR_LOCATIONS
PO_IMPORT_SOURCES_V
PO_INSPECTION_RESULTS_VAL_V
PO_ITEM_HISTORY_V
PO_ITEM_SOURCES

PO_JOB_ASSOCIATIONS

PO_LINES_ALL_EXT_VL
PO_LINES_ALL_V
PO_LINES_AP_V
PO_LINES_ARCHIVE_XML
PO_LINES_CHANGE_PRINT
PO_LINES_INQ_V
PO_LINES_MERGE_V
PO_LINES_PRINT
PO_LINES_RELEASE_ITEMS_V
PO_LINES_RFQQT_V
PO_LINES_SUPPLIER_ITEMS_ALL_V
PO_LINES_SUPPLIER_ITEMS_V
PO_LINES_TRX_V
PO_LINES_V
PO_LINES_VAL_TRX_V
PO_LINES_VAL_V
PO_LINES_XML
PO_LINE_LOCATIONS_ALL_EXT_VL
PO_LINE_LOCATIONS_AP_V
PO_LINE_LOCATIONS_ARCHIVE_XML
PO_LINE_LOCATIONS_CHANGE_PRINT
PO_LINE_LOCATIONS_INQ_V
PO_LINE_LOCATIONS_MERGE_V
PO_LINE_LOCATIONS_PRINT
PO_LINE_LOCATIONS_RELEASE_V
PO_LINE_LOCATIONS_RFQQT_V
PO_LINE_LOCATIONS_TRX_V
PO_LINE_LOCATIONS_V
PO_LINE_LOCATIONS_XML
PO_LINE_TYPES_ALL_V
PO_LINE_TYPES_V
PO_LINE_TYPES_VAL_V
PO_LINE_TYPES_VL
PO_LOCATIONS_VAL_V
PO_LOOKUP_CODES
PO_LOOKUP_CODES_PAY_GROUP_AP_V
PO_LOOKUP_TYPES
PO_MASSCANCEL_INTERIM_V
PO_NEGOTIATED_SOURCES_V
PO_NOTIFICATION_CTRL_MERGE_V
PO_NOTIFICATION_DETAILS_V
PO_OWNED_LINES
PO_OWNED_REQUISITION_LINES
PO_OWNED_SHIPMENTS
PO_POSITIONS_VAL_V
PO_POS_ALL_TRX_V
PO_POS_ALL_V
PO_POS_VAL_TRX_V
PO_POS_VAL_V
PO_PO_SUPPLY_VIEW
PO_PRICE_DIFFERENTIALS_V
PO_PRICE_DIFF_LOOKUPS_V
PO_PRICE_DIFF_MERGE_V
PO_PURCHASE_HISTORY_V
PO_PURCHASE_ORDER_V
PO_QUALITY_CODES_VAL_V
PO_QUOTATIONS_TO_APPROVE
PO_QUOTATION_APPROVALS_V
PO_RCV_CONTROL_LEVEL_V
PO_RCV_SUPPLY_VIEW
PO_RECEIVED_VIA_VAL_V
PO_RELEASES_ALL_V
PO_RELEASES_V
PO_RELEASES_VAL_V
PO_RELEASE_ARCHIVE_XML
PO_RELEASE_XML
PO_REL_LINE_V
PO_REL_TAX_LINES_SUMMARY_V
PO_REQEXPRESS_LINES_V

PO_REQS_IN_POOL_SEC_V

PO_REQS_IN_POOL_V
PO_REQS_IN_TRANSIT_ALL_V
PO_REQUESTOR_LOCATIONS_V
PO_REQUISITION_HEADERS_ALL_V
PO_REQUISITION_HEADERS_INQ_V
PO_REQUISITION_HEADERS_V
PO_REQUISITION_LINES_ALL_MRC_V
PO_REQUISITION_LINES_INQ_V
PO_REQUISITION_LINES_MRC_V
PO_REQUISITION_LINES_V
PO_REQUISITION_TEMPLATES_V
PO_REQ_DISTRIBUTIONS_EXT_VL
PO_REQ_DISTRIBUTIONS_INQ_V
PO_REQ_DISTRIBUTIONS_V
PO_REQ_HEADERS_EXT_VL
PO_REQ_HEADERS_TRX_V
PO_REQ_LINES_EXT_VL
PO_REQ_LINES_IN_POOL_SEC_V

PO_REQ_LINES_IN_POOL_SRC_V

PO_REQ_LINES_TRX_V
PO_REQ_SUPPLY_VIEW
PO_REQ_TAX_LINES_SUMMARY_V
PO_RFQQT_DOCUMENT_STATUS_V
PO_RFQQT_DOCUMENT_TYPES_ALL_V
PO_RFQS_ALL_V
PO_RFQS_FOR_QUOTE_ALL_V
PO_RFQS_VAL_V
PO_RFQ_HEADERS_PRINT
PO_RFQ_LINES_PRINT
PO_RFQ_LINE_LOCATIONS_PRINT
PO_RFQ_VENDORS_V
PO_RULE_EXPENSE_ACCOUNTS_V
PO_SGD_ADDRESSES_UDA_V
PO_SGD_DISTRIBUTIONS_V
PO_SGD_HDRS_UDA_V
PO_SGD_HEADERS_V
PO_SGD_LINELOCS_UDA_V
PO_SGD_LINELOCS_V
PO_SGD_LINES_UDA_V
PO_SGD_LINES_V
PO_SGD_MOD_ADDRESSES_UDA_V
PO_SGD_MOD_DISTRIBUTIONS_V
PO_SGD_MOD_HDRS_UDA_V
PO_SGD_MOD_HEADERS_V
PO_SGD_MOD_LINELOCS_UDA_V
PO_SGD_MOD_LINELOCS_V
PO_SGD_MOD_LINES_UDA_V
PO_SGD_MOD_LINES_V
PO_SHIPMENTS_ALL_V
PO_SHIPMENTS_AP_V
PO_SHIPMENTS_VAL_V
PO_SHIP_RCV_SUPPLY_VIEW
PO_SHIP_SUPPLY_VIEW
PO_SHIP_TO_LOC_ORG_V
PO_SOURCE_SHIPMENT_NUM_V
PO_SOURCE_VENDORS_V

PO_STYLE_ENABLED_LINE_TYPES

PO_STYLE_ENABLED_PAY_ITEMS

PO_SUPPLIERS_ALL_V
PO_SUPPLIERS_VAL_V
PO_SUPPLIER_CONTACTS_VAL_V
PO_SUPPLIER_OPEN_POS_V
PO_SUPPLIER_PO_SITES_VAL_V
PO_SUPPLIER_SITES_ALL_V
PO_SUPPLIER_SITES_VAL_V
PO_SUPPLIER_USERS_V
PO_TAX_CODES_SUMMARY_V
PO_TAX_DISTRIBUTIONS_DETAIL_V
PO_TAX_HEADERS_DETAIL_V
PO_TAX_LINES_DETAIL_V
PO_TAX_LINES_SUMMARY_V
PO_TAX_SHIPMENTS_DETAIL_V
PO_TEMP_LABOR_HEADERS_V
PO_TEMP_LABOR_LINES_V

PO_TEMP_LABOR_RATES_V

PO_TRANSACTION_NATURE_ALL_V
PO_UDA_AG_TEMPLATES_VL
PO_UDA_DUMMY_ALL_EXT_VL
PO_UNITS_OF_MEASURE_VAL_V
PO_UN_NUMBERS_V
PO_UN_NUMBERS_VAL_V
PO_UN_NUMBERS_VL
PO_VENDORS_VIEW
PO_VENDOR_LIST_ENTRIES_V
PO_VENDOR_SITES

PO_WF_NOTIFICATIONS_V

RCV_AEL_GL_V
RCV_AEL_SL_MRC_V
RCV_AEL_SL_V
RCV_CONFIRM_RECEIPT_V
RCV_CORRECTIONS_V
RCV_COR_SUP_LOTS_V
RCV_DISTRIBUTIONS_PRINT
RCV_DISTRIBUTIONS_PRINT_INV
RCV_DISTRIBUTIONS_PRINT_PO
RCV_DISTRIBUTIONS_PRINT_REQ
RCV_DISTRIBUTIONS_PRINT_RMA
RCV_ENTER_RECEIPTS_ASN_V
RCV_ENTER_RECEIPTS_INTERNAL_V
RCV_ENTER_RECEIPTS_INT_REQ_V
RCV_ENTER_RECEIPTS_INVENTORY_V
RCV_ENTER_RECEIPTS_PO_V
RCV_ENTER_RECEIPTS_RMA_V
RCV_ENTER_RECEIPTS_SUPPLIER_V
RCV_ENTER_RECEIPTS_SUP_INT_V
RCV_ENTER_RECEIPTS_V
RCV_FTE_HEADERS_V
RCV_FTE_LINES_V
RCV_FTE_TRANSACTIONS_V
RCV_MSH_V
RCV_MSL_V
RCV_MUR_V
RCV_OPSM_CUSTOMERADDRESS_V
RCV_OPSM_LINE_V
RCV_OPSM_LOT_SERIAL_V
RCV_OPSM_MANUFACT_ADDRESS_V
RCV_PO_ITEMS_V
RCV_RECEIPTS_ALL_V
RCV_RECEIPTS_PRINT
RCV_RECEIPTS_PRINT_INV
RCV_RECEIPTS_PRINT_PO
RCV_RECEIPTS_PRINT_REQ
RCV_RECEIPTS_PRINT_RMA
RCV_RECEIVERS_UNORDERED_V
RCV_RECEIVING_ACCT_DISTR_V
RCV_RECEIVING_PARAMETERS_V
RCV_RECEIVING_VALUE_VIEW
RCV_REC_ACCT_DISTR_MRC_V
RCV_REC_SUB_LEDGER_MRC_V
RCV_RETURNS_V
RCV_ROUTING_HEADERS
RCV_SERIAL_CORRECTION_V
RCV_SHIPMENT_HEADERS_MRC_V
RCV_SHIPMENT_HEADERS_V
RCV_SHIPMENT_LINES_MRC_V
RCV_SOURCES_BOTH_VAL_V
RCV_SUB_LEDGER_DET_MRC_V
RCV_SUPPLIERS_VAL_V
RCV_TRANSACTIONS_MRC_V
RCV_TRANSACTIONS_V
RCV_TRX_INT_LOTS_V
RCV_TRX_INT_SERIALS_V
RCV_UNPROCESSED_LOTS_V
RCV_UNPROCESSED_LOT_ISSUES_V
RCV_VIEW_INTERFACE_V
RCV_VRC_HDS_V
RCV_VRC_TXS_CUST_V
RCV_VRC_TXS_INT_V
RCV_VRC_TXS_V
RCV_VRC_TXS_VENDINT_V
REQ_ENC_AEL_GL_V
UDA_SETUP_METADATA_V
oracle-apps-R12-PO-Purchasing-tables-views

DESCRIPTION

EDW PO Vendor Hierarchies

The FND_FUNCTION_PARAMETER_MAP table contains seed data for notification viewer

This table is obsolete in release 11.

Purchase order acceptances
Accrual accounts temporary table
Accrual Reconciliation Report temporary table
Accrual write-offs
archive for euro functional currency project
Document approval and control action history table
Buyers table
Purchasing document approval list
Purchasing doument lines approval list
Approved supplier list

Approved supplier list attributes

Approved supplier list documents

Approved supplier list status rules

Approved supplier list statuses
No longer used
Archive table for PO_ATTRIBUTE_VALUES
Interface table for PO_ATTRIBUTE_VALUES
Archive table for PO_ATTRIBUTE_VALUES_TLP
Interface table form PO_ATTRIBUTE_VALUES_TLP
Stores descriptor values for records that are searchable in iProcurement
Draft table for PO_ATTRIBUTE_VALUES

Stores translatable descriptor values for records that are searchable in iProcurement

Draft table for PO_ATTRIBUTE_VALUES_TLP

Autocreate UDA rules
No longer used
No longer used
No longer used

It contains values for most of the sources used as Transaction Objects in XLA for PO. This is one of
the main tables on which those Transaction objects derive values for core PO sources.
PO_CHANGE_ORDER_TOLERANCES_ALL  table stores the tolerances.
PO_CHANGE_REQUEST table stores the change requests for Purchase Orders, Releases and
Requisitions submitted by Suppliers or Requesters
Stores the information FPDS - NG Agencies
Stores the information regarding PALT Assignment action history
Stores the information of the Milestones in PALT assignment
Assignments Table
Stores the information for FPDS-NG Car Logs
Stores the information for FPDS-NG Cars
Milestone Templates Table.
CLM Milestones table
MIPR Action History Table
Mapping between FPDS-NG Award Types and PO Award Types
This storres the closeout preferences for each document
Commodities
A table holding translated names and descriptions for Commodities
List of Categories in Commodities
Roles granted to employees for Commodities
Control document type functions
Document authorization groups
Document authorization rules
archive for euro functional currency project
This table stores the association of CWK with Purchase Orders

Purchase order distributions

archive for euro business support project - Not in Use
Stores UDA data of the Purchase order distributions
Stores UDA data of the Purchase order distributions
Archived distributions
Purchase order distributions draft

For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is
used for internal processing of data for PO Approval Submission Checks.

For Internal Use Only: This table is global temporary table based on po_distributions_all table. It is
used for internal processing of data for PO Approval Submission Checks.

Interface table for purchase order distributions

PO_DOC_STYLE_HEADERS contains information about the document style you use in your
business.

PO_DOC_STYLE_LINES_B contains document subtype level information in a document style.

PO_DOC_STYLE_LINES_TL contains translatable information for a line in a document style.

PO_DOC_STYLE_VALUES contains information for the values which are allowed based on a
document style.
Document types
Translated document types
Control table for draft changes

Employee and position hierarchies

For Internal Use Only

Table to store locks for Modification entities

This stores the exhibit details for each document

This stores the archived exhibit details for each document
This stores the draft exhibit details for each modifications
Global Agreements Org Assignments
Global Agreements Org Assignments
Archived Global Agreements Org Assignments
Hazardous classes
Translated hazardous classes

Document headers (for purchase orders, purchase agreements, quotations, RFQs)

archive for euro business support project

Archived UDA data of the Document headers (for purchase orders, purchase agreements)

Stores the UDA data of the Document headers (for purchase orders, purchase agreements,
quotations, RFQs)

Translated archive UDA data of the Document headers (for purchase orders, purchase agreements)

Archived purchase orders

Draft Document headers (for purchase orders, purchase agreements, quotations, RFQs)

For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used
for internal processing of data for PO Approval Submission Checks.

For Internal Use Only: This table is global temporary table based on po_headers_all table. It is used
for internal processing of data for PO Approval Submission Checks.

Interface table for purchase order headers

Purged purchase orders
Purged receipts
Purged requisitions
Purged suppliers
Requisition import interface errors
Associates HR jobs with Purchasing categories.
Provides descriptions for HR jobs in multiple languages.

Archived UDA data of Document shipment schedules (for purchase orders, purchase agreements)

Translated Archive UDA data of Document shipment schedules (for purchase orders, purchase
agreements)

Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)

archive for euro business support project

Stores the UDA data of Document shipment schedules (for purchase orders, purchase agreements,
quotations, RFQs)
Stores the UDA data of Document shipment schedules (for purchase orders, purchase agreements,
quotations, RFQs)
Archived purchase order shipments
Draft table for PO_LINE_LOCATIONS_ALL

For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is
used for internal processing of data for PO Approval Submission Checks.

For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is
used for internal processing of data for PO Approval Submission Checks.

Interface table for purchase order line locations

Line types
Translated line types

Purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)

archive for euro business support project

Stores the UDA data of Purchase document lines (for purchase orders, purchase agreements,
quotations, RFQs)

Archived UDA data of Purchase document lines (for purchase orders, purchase agreements)

Stores the UDA data of Purchase document lines (for purchase orders, purchase agreements,
quotations, RFQs)
Translated Archive UDA data of Purchase document lines (for purchase orders, purchase
agreements)
Archived purchase order lines
Draft table for purchase document lines (for purchase orders, purchase agreements, quotations,
RFQs)

For Internal Use Only: This table is global temporary table based on po_lines_all table. It is used for
internal processing of data for PO Approval Submission Checks.

For Internal Use Only: This table is global temporary table based on po_lines_all table. It is used for
internal processing of data for PO Approval Submission Checks.

Interface table for purchase order lines

Location associations to customers and customer sites
Location associations to customers and customer sites
MassCancel rules
MassCancel temporary table
Multiple Reporting Currencies (MRC) sub-table of PO_DISTRIBUTIONS_ALL
MRC sub-table of PO_HEADERS

This table stores the Supplier related changes pertaining to a Multiple Modifications Request.

This table stores the documents that are selected for a Multiple Modifications Request.

This table serves as the control table for Multiple Modifications and Supplier Change Requests.

This table stores the Supplier exceptions generated for a Multiple Modifications Request.

Note attributes
Document/notes references
No longer used
Blanket agreement and planned purchase order notification controls
Blanket agreement and planned purchase order notification controls draft table
Notifications

Online report errors

Job/organization and position controls
Data for the Price Adjustments Attributes.
Archive data for Price Adjustments Attributes.
Draft table for Price Adjustments Attributes.
Stores information regarding the Price Adjustments
Stores history regarding the Price Adjustments
Draft table for the Price Adjustments.
Draft Table for price differentials for rate-based lines.
Price differentials for rate based lines
Price differentials for rate-based lines
Price differentials for rate based lines
Federal Printing Formats

Purchase order candidates for purging

Receiving candidates list for purge process. Temporary table.
Requisition candidates for purging
Supplier candidates for purging
Quality inspection codes
Quotation approvals
Charge Allocations table
Table for Freight and Special Charge records
Not used in Release 11i
Purchase order releases
archive for euro business support project
Archived releases
Interface table for requisition distributions
Requisition distributions
archive for euro functional currency project
Stores the UDA data for the Requisition Distributions.
Stores the UDA data for the Requisition Distributions.

Stores the UDA data for the Requisition headers

Stores the UDA data for the Requisition Lines
Stores the UDA data for the Requisition Lines

For Internal Use Only: This table is global temporary table based on po_requisition_lines_all table. It
is used for internal processing of data for PO Approval Submission Checks.

Template headers for express requisitions

Template lines for express requisitions
Requisition headers
Requisition lines
archive for euro functional currency project
This table holds the list of suppliers to which the contractor request is sent out
archive for euro functional currency project
Requisition Import interface table
Requisition reschedule interface table
Retrieved Timecards

For Internal Use Only: PO_RETROPRICE_GT is used to write the results of the bulk selects in the
procedure PO_RETROACTIVE_PRICING_PVT.MassUpdate_Releases. This is then used later to
update the tables using bulk processing.

Suppliers on an RFQ
Expense charge account rules.
Supplier capacity information

Supplier capacity tolerance information

Purchasing options
Stores information regarding the Attribute Group Template Usages
Stores the information regarding the Attribute Templates
Stores the information regarding the Attribute Templates
Dummy Table for UDA Seeding purposes
Stores the UDA data of the Dummy Table for UDA Seeding purposes
Stores the UDA data of the Dummy Table for UDA Seeding purposes
Interface table for importing UDA Data
Holds the data of the Mapping Between Dummy and Real Attribute Group types
United Nations numbers
Translated United Nations numbers
Purchase order document number control
Note usage attributes
Note usages
Table to Store User preferences
This table stores warrant information

Supplier contacts
Supplier contacts

RFQ supplier list entries

RFQ supplier list headers
Supplier sites
archive for euro business support project
Supplier sites
Suppliers
archive for euro business support project
Suppliers

This table stores warrant lines information.

Temporary table to store requisition lines that can be automatically created using workflow

This table is reserved for use by Oracle only

Purchase details and analysis based on contracts

archive for euro functional currency project
Temporary table for Purchasing Intelligence reports.
archive for euro functional currency project
archive for euro functional currency project
Summary information to compare suppliers for an item

Stores the UDA Attributes of the negotiations header level details.

Stores the UDA attibutes of negotiation item details including price
Stores the UDA attibutes of negotiation item details including price
Stores the UDA attributes of header level data for a response to a negotiation
Stores the UDA attributes of header level data for a response to a negotiation
Stores the UDA data of the information regarding the responses submitted by a supplier on a
negotiation.
Stores the UDA data of the information regarding the responses submitted by a supplier on a
negotiation.
Receiving Accounting Event Types
Receiving Accounting Events
Interface table for charges
Receiving logistics transaction lines
Gapless Invoice Numbers for Self Billing Invoices

RCV_HEADERS_INTERFACE is the interface table that stores receiving header information.

Receiving lots transactions

Receiving lots interface table
Receiving lots supply
MRC sub-table of RCV_RECEIVING_SUB_LEDGER
MRC sub-table of RCV_SHIPMENT_HEADERS
MRC sub-table of RCV_SHIPMENT_LINES
MRC sub-table of RCV_SUB_LEDGER_DETAILS
MRC sub-table of RCV_TRANSACTIONS
Organization-level receiving controls
Receiving subledger
Receiving routing headers
Receiving routing headers
Receiving routing steps
Receiving serial transactions
Receiving serial interface table
Receiving serial supply
Shipment and receipt header information
Receiving shipment line information
archive for euro functional currency project
Receiving transactions for subcontracted items
Detailed accounting lines for the receiving transaction
Summary information about items in receiving/inspection
Receiving transactions
Receiving transactions interface table
Temporary table for tracking a receiving upgrade from Release 9 to Release 10

DESCRIPTION
Geography Mapping View

Lookup Code Level Collection View

Lookup Code Key View
EDW Lookup Dimension Mapping View

EDW Line Type Mapping View

EDW Supplier Item Mapping View

EDW Trading Partner Mapping View

 - Retrofitted
 - Retrofitted
Employees view
 - Retrofitted
Current employees view
 - Retrofitted
 - Retrofitted
EDW Contract Agreement LIne Fact Collection View
EDW Contract Agreement Fact Collection View
EDW PO Distribution Fact Collection View

EDW Supplier Performance Fact Collection View

This view resolves the foreign key references in  POA_BIS_SAVINGS table. Please refer to the base
table  for further information.

This view is based on the POA_BIS_SUPPLIER_PERFORMANCE table. Please refer to the base
view for further information.

EDW Contract Agreement Lines Fact Collection View

EDW Contract Agreement Fact Collection View

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
Referenced Contract Number
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
Create ASN View

10SC ONLY
 - Retrofitted
10SC ONLY
Accommodates dynamic SQL built for security user exit
10SC ONLY
 - Retrofitted
Blanket purchase agreements
Contract purchase orders
Contract purchase order total amount
Planned purchase order
Planned purchase order total amount
PO_ALL_DOC_STYLE_LINES contains information about all the document style lines for all the
document subtypes.
 - Retrofitted
PO_ASL_V view displays only enabled ASL's.

PO_AP_RETROACTIVE_DIST_V view captures the distributions to be invoice adjusted..

 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
10SC ONLY
 - Retrofitted
10SC ONLY
10SC ONLY
10SC ONLY

Purchase order information by buyer

10SC ONLY
View that gives all the CLM Operation Units
Multilingual view for Commodities
10SC ONLY

10SC ONLY
10SC ONLY

 - Retrofitted

Purchase order distributions

 - Retrofitted
The merged view using PO_DISTRIBUTIONS_ALL table and
PO_DISTRIBUTIONS_DRAFT_ALL tables.
 - Retrofitted
 - Retrofitted
Requisition Distribution View.
10SC ONLY

Header information in PO_HEADERS, PO_RELEASES, and PO_REQUISITION_HEADERS

 - Retrofitted
This view is required to provide version information on documents for contracts.
PO_DOC_STYLE_LINES_VL contains information about a document style line in the user session
language.

Used for XML mapping in the distribution level

 - Retrofitted
10SC ONLY

10SC ONLY
10SC ONLY
Global Agreements Org Assignment View.

10SC ONLY
10SC ONLY

 - Retrofitted
10SC ONLY

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
View on po_headers table.
10SC ONLY
Document headers

10SC ONLY
 - Retrofitted
Requisition Import
10SC ONLY
Replaces PO_ITEM_HISTORY table
Sources for an item
Single-language view for Job-Category Associations. Shows the descriptions in the current session
language.

10SC ONLY
10SC ONLY

 - Retrofitted
 - Retrofitted

 - Retrofitted
10SC ONLY
 - Retrofitted
10SC ONLY
10SC ONLY
View on po_lines table.
10SC ONLY
Po Lines view.
10SC ONLY - Retrofitted

10SC ONLY

 - Retrofitted
10SC ONLY - Retrofitted

 - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
View on po_line_locations table.
 - Retrofitted

10SC ONLY - Retrofitted

 - Retrofitted
10SC ONLY - Retrofitted

 - Retrofitted

10SC ONLY - Retrofitted

 - Retrofitted
Negotiated Sources
Security view for owned purchase order lines
Security view for owned requisition lines
Security view for owned purchase order shipments

PUB
10SC ONLY - Retrofitted
PUB
10SC ONLY - Retrofitted
Purchasing supply
This view is used as the base view for the Price Differentials form.
The View contains the Price differentials used by PO

 - Retrofitted
Purchase order
10SC ONLY - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted
Receiving supply
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted

 - Retrofitted

 - Retrofitted
This view was created for HTML Autocreate. This view retrieves the requisition headers that have
one or more lines that are currently in the pool (i.e. eligible for Autocreate), in the operating units
specified by the MO: Security Profile p
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
Employee's location, given employee ID and optionally organization
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted

Requisition headers view.

This view shows all the requisition lines which are available in the pool from Oracle sourcing point
of view. That is the where clause does not check for reqs_in_pool_flag='Y'.

Requisition Lines View.

Requisition supply

10SC ONLY - Retrofitted

10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
Print view of RFQ headers
Print view of RFQ lines
Print view of RFQ line locations
 - Retrofitted

10SC ONLY - Retrofitted

10SC ONLY
10SC ONLY - Retrofitted
Shipment receipts supply
Purchasing shipment supply
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
 - Retrofitted
PO_STYLE_ENABLED_LINE_TYPES contains information for the line types which are allowed
based on a document style.
PO_STYLE_ENABLED_PAY_ITEMS contains information for the pay items which are allowed
based on a document style.
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted

Retrieves information on approved standard POs with Temp Labor lines.

Retrieves information on Temp Labor lines.

Retrieves rate information for Temp Labor lines and their price differentials on Standard POs.

10SC ONLY - Retrofitted

 - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted

Suppliers view
 - Retrofitted
10SC ONLY - Retrofitted

Information about purchase orders, releases and requisitions that have outstanding notifications

View for GL Drilldown

PO view accounting View

 - Retrofitted
10SC ONLY - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
Header Lines for logistics
Transaction Lines for logistics
Rolled up transactions for logistics
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted

 - Retrofitted
10SC ONLY - Retrofitted
Print view of receipts
Print view of receipts
Print view of receipts
Print view of receipts
Print view of receipts
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted - Retrofitted
 - Retrofitted
Receiving Value Report

 - Retrofitted
 - Retrofitted
View on FND_LOOKUPS for receiving routing types
 - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted
 - Retrofitted
10SC ONLY - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
New in version 8.0
New in version 8.0
 - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
10SC ONLY - Retrofitted
Oracle Inventory Management Tables:
ABLE NAME
ADS_LOCATORS_V
COST_UPGR_ERROR_TABLE
EDW_CST_COGS_F
EDW_CST_COGS_FSTG
EDW_MTL_UOM_CLS_CONV_F
EDW_MTL_UOM_CLS_CONV_FSTG
EDW_MTL_UOM_CONV_F
EDW_MTL_UOM_CONV_FSTG
INV_DIAG_MSN_TEMP
INV_EID_MMT_DATE_TMP
INV_EID_MOQD_DATE_TMP
INV_EID_PF_DATE_TMP
INV_EID_RSV_DATE_TMP
INV_EID_TASK_DATE_TMP
INV_EID_TF_DATE_TMP
INV_ITEM_TEMP

MTL_3PL_LOCATOR_OCCUPANCY

MTL_ABC_ASSGN_GROUP_CLASSES
MTL_ABC_ASSIGNMENT_GROUPS
MTL_ABC_ASSIGNMENTS
MTL_ABC_CLASSES
MTL_ABC_COMPILE_HEADERS
MTL_ABC_COMPILE_HEADERS_EFC
MTL_ABC_COMPILES
MTL_ABC_COMPILES_EFC
MTL_ACTIONS_B
MTL_ACTIONS_TL
MTL_ACTUAL_COST_SUBELEMENT
MTL_ACTUAL_COST_SUBELEMENT_EFC
MTL_ADJUSTMENT_SYNC_TEMP
MTL_ATP_RULES

MTL_ATTR_APPL_DEPENDENCIES

MTL_AVAILABLE_INVENTORY_TEMP
MTL_BILLING_RULE_HEADERS_B
MTL_BILLING_RULE_HEADERS_TL
MTL_BILLING_RULE_LINES

MTL_BILLING_SOURCES_B

MTL_BILLING_SOURCES_TL
MTL_BIS_INV_BY_PERIOD

MTL_CATALOG_SEARCH_ITEMS
MTL_CATEGORIES_B

MTL_CATEGORIES_TL

MTL_CATEGORY_ACCOUNTS

MTL_CATEGORY_SET_VALID_CATS
MTL_CATEGORY_SETS_B

MTL_CATEGORY_SETS_TL

MTL_CC_ENTRIES_INTERFACE
MTL_CC_INTERFACE_ERRORS
MTL_CC_SCHED_COUNT_XREFS
MTL_CC_SCHEDULE_REQUESTS
MTL_CC_SERIAL_NUMBERS

MTL_CC_SUBINVENTORIES

MTL_CHILD_LOT_NUMBERS
MTL_CI_INTERFACE
MTL_CI_XREFS_INTERFACE
MTL_CLIENT_PARAMETERS
MTL_COGS_RECOGNITION_TEMP
MTL_COMMODITY_CODES

MTL_CONSIGNED_DIAG_ERRORS

MTL_CONSUMPTION_DEFINITION

MTL_CONSUMPTION_TRANSACTIONS

MTL_CONSUMPTION_TXN_TEMP

MTL_COPY_ORG_INTERFACE

MTL_COPY_ORG_REPORT

MTL_COUNTRY_ASSIGNMENTS

MTL_CROSS_REFERENCE_TYPES
MTL_CROSS_REFERENCES
MTL_CROSS_REFERENCES_B
MTL_CROSS_REFERENCES_INTERFACE

MTL_CROSS_REFERENCES_TL

MTL_CST_ACTUAL_COST_DETAIL_EFC
MTL_CST_ACTUAL_COST_DETAILS
MTL_CST_LAYER_ACT_COST_DETAILS
MTL_CST_TXN_COST_DETAILS
MTL_CST_TXN_COST_DETAILS_EFC
MTL_CUSTOMER_ITEM_XREFS
MTL_CUSTOMER_ITEMS
MTL_CYCLE_COUNT_CLASSES
MTL_CYCLE_COUNT_CLASSES_EFC
MTL_CYCLE_COUNT_ENTRIES
MTL_CYCLE_COUNT_ENTRIES_EFC
MTL_CYCLE_COUNT_HEADERS
MTL_CYCLE_COUNT_HEADERS_EFC
MTL_CYCLE_COUNT_ITEMS
MTL_DEFAULT_CATEGORY_SETS
MTL_DEMAND
MTL_DEMAND_HISTORIES
MTL_DEMAND_INTERFACE
MTL_DESC_ELEM_VAL_INTERFACE
MTL_DESCR_ELEMENT_VALUES
MTL_DESCRIPTIVE_ELEMENTS
MTL_EAM_ASSET_ACTIVITIES
MTL_EAM_ASSET_ATTR_GROUPS
MTL_EAM_ASSET_ATTR_VALUES
MTL_EAM_ASSET_NUM_INTERFACE
MTL_EAM_ASSET_SEARCH_TEMP
MTL_EAM_ATTR_VAL_INTERFACE
MTL_EAM_LOCATIONS
MTL_EAM_NETWORK_ASSETS
MTL_ECONOMIC_ZONES_B

MTL_ECONOMIC_ZONES_TL

MTL_ERES_TRANSACTIONS_GTMP
MTL_EXT_OBJECTS
MTL_FISCAL_CAT_ACCOUNTS

MTL_FLEX_CONTEXT

MTL_FORECAST_RULES
MTL_GEN_TEMP
MTL_GENERIC_DISPOSITIONS
MTL_GRADE_STATUS_ERES_GTMP
MTL_GRADES_B
MTL_GRADES_TL

MTL_ICG_ALIASES

MTL_ICG_CATEGORIES

MTL_INTERCOMPANY_PARAMETERS
MTL_INTERFACE_ERRORS
MTL_INTERFACE_PROC_CONTROLS
MTL_INTERORG_PARAMETERS

MTL_INTERORG_SHIP_METHODS

MTL_INV_PACKSLIPS
MTL_INV_PICKING_RULES
MTL_ITEM_ATTRIBUTES

MTL_ITEM_ATTRIBUTES_SEED_INFO

MTL_ITEM_ATTRIBUTES_TEMP
MTL_ITEM_BULKLOAD_RECS
MTL_ITEM_CATALOG_GROUPS_B

MTL_ITEM_CATALOG_GROUPS_TL

MTL_ITEM_CATEGORIES

MTL_ITEM_CATEGORIES_INTERFACE

MTL_ITEM_CHILD_INFO_INTERFACE
MTL_ITEM_ENDECA_TEMP
MTL_ITEM_LOC_DEFAULTS
MTL_ITEM_LOCATIONS
MTL_ITEM_REVISIONS_B
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_REVISIONS_TL
MTL_ITEM_STATUS
MTL_ITEM_STATUS_TL

MTL_ITEM_SUB_DEFAULTS

MTL_ITEM_SUB_INVENTORIES
MTL_ITEM_SUB_INVS_INTERFACE
MTL_ITEM_TEMPL_ATTRIBUTES
MTL_ITEM_TEMPLATES
MTL_ITEM_TEMPLATES_B
MTL_ITEM_TEMPLATES_TL

MTL_ITEM_VALUES_TEMP

MTL_KANBAN_CARD_ACTIVITY
MTL_KANBAN_CARD_PRINT_TEMP
MTL_KANBAN_CARDS
MTL_KANBAN_PULL_SEQUENCES
MTL_KANBAN_TEMPLATES

MTL_LE_ECONOMIC_ZONES

MTL_LOT_CONV_AUDIT
MTL_LOT_CONV_AUDIT_DETAILS
MTL_LOT_ERES_GTMP

MTL_LOT_GRADE_HISTORY

MTL_LOT_NUMBERS
MTL_LOT_UOM_CLASS_CONVERSIONS
MTL_LOTATT_SYNC_REPORT_TEMP
MTL_LPN_ATR_QTY_GT
MTL_LSP_ONHAND_BALANCE_TMP
MTL_MANUFACTURERS
MTL_MATERIAL_STATUS_HISTORY
MTL_MATERIAL_STATUSES

MTL_MATERIAL_STATUSES_B

MTL_MATERIAL_STATUSES_TL

MTL_MATERIAL_TRANSACTIONS
MTL_MATERIAL_TRANSACTIONS_EFC
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_MATERIAL_TXN_ALLOCATIONS
MTL_MFG_PART_NUMBERS
MTL_MGD_INVENTORY_POSITIONS
MTL_MOBILE_LOGIN_HIST
MTL_MOQD_BACKUP
MTL_MOVEMENT_PARAMETERS

MTL_MOVEMENT_STATISTICS

MTL_MOVEMENT_STATISTICS_EFC

MTL_MVT_STATS_RULE_SETS_B
MTL_MVT_STATS_RULE_SETS_TL

MTL_MVT_STATS_RULES

MTL_MWB_GTMP
MTL_OBJECT_EVENTS
MTL_OBJECT_GENEALOGY
MTL_OBJECT_GENEALOGY_INTERFACE
MTL_ONHAND_LOCK_TEMP
MTL_ONHAND_QUANTITIES
MTL_ONHAND_QUANTITIES_DETAIL
MTL_ONHAND_QUANTITY_TEMP
MTL_ORG_REPORT_TEMP

MTL_PAC_ACT_CST_DTL_TEMP

MTL_PAC_ACTUAL_COST_DETAIL_EFC
MTL_PAC_ACTUAL_COST_DETAILS

MTL_PAC_COST_SUBELEMENTS

MTL_PAC_COST_SUBELEMENTS_EFC
MTL_PAC_TXN_COST_DETAILS
MTL_PAC_TXN_COST_DETAILS_EFC
MTL_PARAMETERS
MTL_PENDING_ITEM_STATUS
MTL_PER_CLOSE_DTLS
MTL_PER_CLOSE_DTLS_EFC

MTL_PERIOD_CG_SUMMARY

MTL_PERIOD_SUMMARY
MTL_PERIOD_SUMMARY_EFC
MTL_PHYSICAL_ADJUSTMENTS
MTL_PHYSICAL_ADJUSTMENTS_EFC
MTL_PHYSICAL_INVENTORIES
MTL_PHYSICAL_INVENTORIES_EFC
MTL_PHYSICAL_INVENTORY_TAGS
MTL_PHYSICAL_SUBINVENTORIES
MTL_PICK_SLIP_NUMBERS
MTL_PICKING_RULES
MTL_PLANNERS
MTL_PO_PACKSLIPS

MTL_PULL_SEQ_SUPPLIERS
MTL_PURGE_HEADER
MTL_QOH_ITEM_TMP
MTL_QOH_LOCATOR_TMP
MTL_QOH_LOT_TMP
MTL_QOH_REV_TMP
MTL_QOH_SUB_TMP
MTL_RELATED_ITEMS
MTL_RELATED_ITEMS_CUST_REF
MTL_RELATED_ITEMS_INTERFACE
MTL_RELATED_ITEMS_PLN_INFO
MTL_REPLENISH_HEADERS
MTL_REPLENISH_HEADERS_INT
MTL_REPLENISH_LINES
MTL_REPLENISH_LINES_INT
MTL_RESERVATIONS
MTL_RESERVATIONS_INTERFACE
MTL_RMA_SERIAL_TEMP
MTL_RTG_ITEM_REVISIONS
MTL_RTG_ITEM_REVS_INTERFACE
MTL_SAFETY_STOCKS
MTL_SALES_ORDERS
MTL_SEASONALITY_INDICES
MTL_SECONDARY_INVENTORIES
MTL_SECONDARY_LOCATORS
MTL_SECONDARY_LOCS_INTERFACE
MTL_SERIAL_NUMBERS
MTL_SERIAL_NUMBERS_GT

MTL_SERIAL_NUMBERS_INTERFACE

MTL_SERIAL_NUMBERS_TEMP

MTL_SERIAL_TAGGING_ASSIGNMENTS

MTL_SHORT_CHK_PARAM
MTL_SHORT_CHK_STATEMENTS
MTL_SHORT_CHK_TEMP

MTL_SO_RMA_INTERFACE
MTL_SO_RMA_RECEIPTS

MTL_STAT_TYPE_USAGES

MTL_STATUS_ATTRIBUTE_VALUES

MTL_STATUS_TRANSACTION_CONTROL

MTL_SUM_DEMD_HIST_GT
MTL_SUMMARY_TEMP
MTL_SUPPLY

MTL_SUPPLY_DEMAND_TEMP

MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_B_EFC
MTL_SYSTEM_ITEMS_INTERFACE

MTL_SYSTEM_ITEMS_TL

MTL_TRANS_REASON_SECURITY

MTL_TRANSACTION_ACCOUNTS
MTL_TRANSACTION_ACCOUNTS_EFC
MTL_TRANSACTION_FLOW_HEADERS
MTL_TRANSACTION_FLOW_LINES
MTL_TRANSACTION_LOT_NUMBERS
MTL_TRANSACTION_LOTS_INTERFACE
MTL_TRANSACTION_LOTS_TEMP
MTL_TRANSACTION_REASONS
MTL_TRANSACTION_TYPES
MTL_TRANSACTIONS_INTERFACE
MTL_TRANSFER_TEMP

MTL_TXN_COST_DET_INTERFACE

MTL_TXN_REQUEST_HEADERS
MTL_TXN_REQUEST_LINES
MTL_TXN_SOURCE_TYPES
MTL_TXNS_HISTORY
MTL_UNIT_TRANSACTIONS
MTL_UNITS_OF_MEASURE_TL
MTL_UOM_CLASS_CONVERSIONS
MTL_UOM_CLASSES_TL

MTL_UOM_CONVERSIONS

MTL_UOM_CONVERSIONS_ERES_GTMP
 MTL_UPDATE_RECORDS_TEMP
MTL_USER_DEMAND
MTL_USER_SUPPLY
MTL_VMI_QUANTITIES_TEMP
ORG_ACCESS
ORG_ACCT_PERIODS
ORG_FREIGHT_TL
ORG_GL_BATCHES
WMS_CARTONIZATION_TEMP
WMS_CARTONIZATION_TEMP1

Oracle Inventory Management  Views:

VIEW NAME
EDW_CST_COGS_F_IV
EDW_MTL_UOM_CLS_CONV_F_IV
EDW_MTL_UOM_CONV_F_IV
ICX_MTL_DEMAND_SUMMARY_V
INVBV_ABC_ASSGN_GROUP_CLASSES
INVBV_ABC_ASSIGNMENTS
INVBV_ABC_ASSIGNMENT_GROUPS
INVBV_ABC_CLASSES
INVBV_CUSTOMER_ITEMS
INVBV_CUSTOMER_ITEM_XREFS
INVBV_CYCLE_COUNTS
INVBV_CYCLE_COUNT_ADJUSTMENTS
INVBV_CYCLE_COUNT_CLASSES
INVBV_CYCLE_COUNT_ITEMS
INVBV_DESCRIPTIVE_ELEMENTS
INVBV_EXTERNAL_ITEM_XREFS
INVBV_EXT_ITEM_XREF_TYPES
INVBV_FREIGHT_CARRIERS
INVBV_FUTURE_ITEM_STATUSES
INVBV_GL_ACCOUNT_ALIASES
INVBV_INTERORG_LEAD_TIMES
INVBV_INTERORG_SHIPPING_INFO
INVBV_INVENTORY_DEMANDS
INVBV_INVENTORY_LOCATORS
INVBV_INVENTORY_ORGANIZATIONS
INVBV_INVENTORY_RESERVATIONS
INVBV_INVENTORY_SUPPLIES
INVBV_INVENTORY_TXN_TYPES
INVBV_INV_BY_PERIOD_AND_ITEM
INVBV_ITEMS
INVBV_ITEM_CATALOG_GROUPS
INVBV_ITEM_CATEGORIES
INVBV_ITEM_CATEGORY_ASGNS
INVBV_ITEM_CATEGORY_TYPES
INVBV_ITEM_CATEGORY_TYPE_ASGNS
INVBV_ITEM_DESC_ELEMENT_VALUES
INVBV_ITEM_RELATIONS
INVBV_ITEM_REPLENISH_COUNTS
INVBV_ITEM_REVISIONS
INVBV_ITEM_STATUS_ATTR_VALUES
INVBV_ITEM_STATUS_CODES
INVBV_KANBAN_CARDS
INVBV_KANBAN_CARD_ACTIVITIES
INVBV_KANBAN_LOCATION_ITEMS
INVBV_LOTS
INVBV_LOT_TRANSACTIONS
INVBV_MANUFACTURERS
INVBV_MATERIAL_TRANSACTIONS
INVBV_MFG_PART_NUMBERS
INVBV_MOVEMENT_PARAMETERS
INVBV_MOVEMENT_STATISTICS
INVBV_MOVE_ORDERS_HEADERS
INVBV_MOVE_ORDERS_LINES
INVBV_ONHAND_BALANCES
INVBV_ORGANIZATION_ITEMS
INVBV_ORG_ITEM_REVISIONS
INVBV_PHYSICAL_ADJUSTMENTS
INVBV_PHYSICAL_INVENTORIES
INVBV_PHYSICAL_INV_COUNTS
INVBV_PRODUCT_FAMILY_MEMBERS
INVBV_SERIAL_NUMBERS
INVBV_SERIAL_NUMBER_TXNS
INVBV_SHIP_METHODS
INVBV_SUBINVENTORIES
INVBV_SUB_REPLENISH_COUNTS
INVBV_TRANSACTION_SOURCE_TYPES
INVBV_UNITS_OF_MEASURE
INVBV_UOM_CLASSES
INVBV_UOM_CLASS_CONVERSIONS
INVBV_UOM_CONVERSIONS
INVFV_ABC_ASSGN_GROUP_CLASSES
INVFV_ABC_ASSIGNMENTS
INVFV_ABC_ASSIGNMENT_GROUPS
INVFV_ABC_CLASSES
INVFV_CUSTOMER_ITEMS
INVFV_CUSTOMER_ITEM_XREFS
INVFV_CYCLE_COUNTS
INVFV_CYCLE_COUNT_ADJUSTMENTS
INVFV_CYCLE_COUNT_CLASSES
INVFV_CYCLE_COUNT_ITEMS
INVFV_DESCRIPTIVE_ELEMENTS
INVFV_EXTERNAL_ITEM_XREFS
INVFV_EXT_ITEM_XREF_TYPES
INVFV_FREIGHT_CARRIERS
INVFV_FUTURE_ITEM_STATUSES
INVFV_GL_ACCOUNT_ALIASES
INVFV_INTERORG_LEAD_TIMES
INVFV_INTERORG_SHIPPING_INFO
INVFV_INVENTORY_DEMANDS
INVFV_INVENTORY_LOCATORS
INVFV_INVENTORY_ORGANIZATIONS
INVFV_INVENTORY_RESERVATIONS
INVFV_INVENTORY_SUPPLIES
INVFV_INVENTORY_TXN_TYPES
INVFV_INV_BY_PERIOD_AND_ITEM
INVFV_ITEMS
INVFV_ITEM_CATALOG_GROUPS
INVFV_ITEM_CATEGORIES
INVFV_ITEM_CATEGORY_ASGNS
INVFV_ITEM_CATEGORY_TYPES
INVFV_ITEM_CATEGORY_TYPE_ASGNS
INVFV_ITEM_DESC_ELEMENT_VALUES
INVFV_ITEM_RELATIONS
INVFV_ITEM_REPLENISH_COUNTS
INVFV_ITEM_REVISIONS
INVFV_ITEM_STATUS_ATTR_VALUES
INVFV_ITEM_STATUS_CODES
INVFV_KANBAN_CARDS
INVFV_KANBAN_CARD_ACTIVITIES
INVFV_KANBAN_LOCATION_ITEMS
INVFV_LOTS
INVFV_LOT_TRANSACTIONS
INVFV_MANUFACTURERS
INVFV_MATERIAL_TRANSACTIONS
INVFV_MFG_PART_NUMBERS
INVFV_MOVEMENT_PARAMETERS
INVFV_MOVEMENT_STATISTICS
INVFV_MOVE_ORDERS_HEADERS
INVFV_MOVE_ORDERS_LINES
INVFV_ONHAND_BALANCES
INVFV_ORGANIZATION_ITEMS
INVFV_ORG_ITEM_REVISIONS
INVFV_PHYSICAL_ADJUSTMENTS
INVFV_PHYSICAL_INVENTORIES
INVFV_PHYSICAL_INV_COUNTS
INVFV_PRODUCT_FAMILY_MEMBERS
INVFV_SERIAL_NUMBERS
INVFV_SERIAL_NUMBER_TXNS
INVFV_SHIP_METHODS
INVFV_SUBINVENTORIES
INVFV_SUB_REPLENISH_COUNTS
INVFV_TRANSACTION_SOURCE_TYPES
INVFV_UNITS_OF_MEASURE
INVFV_UOM_CLASSES
INVFV_UOM_CLASS_CONVERSIONS
INVFV_UOM_CONVERSIONS
INV_3PL_CLIENTS_V
INV_3PL_CONTRACTS_V

INV_BIS_ITEM_COSTS

INV_BIS_SUPPLY_CHAIN_INVENTORY
INV_LOT_SERIAL_COLUMNS_V
INV_LOT_SERIAL_CONTEXT_V
INV_ORGANIZATION_INFO_V
INV_ORGANIZATION_NAME_V

MFG_LOOKUPS

MFG_LOOKUPS_V

MTL_ABC_ASSGNMNT_GROUPS_ALL_V
MTL_ABC_ASSGN_GROUP_CLASSES_V
MTL_ABC_ASSIGNMENTS_V
MTL_ABC_ASSIGNMENT_GROUPS_V
MTL_ABC_CLASSES_ALL_V
MTL_ABC_CLASSES_V
MTL_ABC_CLASSES_VAL_V
MTL_ABC_COMPILES_V
MTL_ABC_COMPILE_HEADERS_V
MTL_ACTIONS_VL
MTL_ADJUSTMENT_LOTSERIAL_V
MTL_ADJ_SYNC_WRAPPER_V
MTL_AGREEMENT_DETAILS_V
MTL_ALL_PRIMARY_UOMS_VV
MTL_ATT_QTY_V
MTL_AVAILABLE_INVENTORY_V
MTL_BILLING_RULE_HEADERS_VL
MTL_BILLING_RULE_LINES_V
MTL_BILLING_SOURCES_VL

MTL_BIS_INV_VALUE_V

MTL_CATALOG_SEARCH_ITEMS_ALL_V
MTL_CATEGORIES_B_KFV
MTL_CATEGORIES_V
MTL_CATEGORIES_VL
MTL_CATEGORY_ACCOUNTS_V

MTL_CATEGORY_GRANTS_V

MTL_CATEGORY_SETS_ALL_V
MTL_CATEGORY_SETS_V
MTL_CATEGORY_SETS_VL
MTL_CATEGORY_SET_VALID_CATS_V
MTL_CC_ENTRIES_INTERFACE_V
MTL_CC_GRAPH_DAY_V
MTL_CC_GRAPH_MONTH_V
MTL_CC_GRAPH_PERIOD_V
MTL_CC_GRAPH_QTR_V
MTL_CC_GRAPH_V
MTL_CC_GRAPH_WK_V
MTL_CC_INTERFACE_ERRORS_V
MTL_CC_SCHEDULES_V
MTL_CC_SUBINVENTORIES_ALL_V
MTL_CLIENT_ITEMS_VL
MTL_CLIENT_PARAMETERS_V
MTL_COMMODITY_CODES_ACTIVE_V
MTL_COMMODITY_CODES_ALL_V
MTL_CONSUMPTION_DEFINITION_V
MTL_COUNTRY_ASSIGNMENTS_V
MTL_CROSS_REFERENCES_SRW_V
MTL_CROSS_REFERENCES_V

MTL_CROSS_REFERENCES_VL

MTL_CST_TXN_COST_DETAILS_V
MTL_CUSTOMER_ITEMS_ACTIVE_V
MTL_CUSTOMER_ITEMS_ALL_V
MTL_CUSTOMER_ITEM_XREFS_V
MTL_CYCLE_COUNT_CLASSES_ALL_V
MTL_CYCLE_COUNT_CLASSES_V
MTL_CYCLE_COUNT_ENTRIES_ALL_V
MTL_CYCLE_COUNT_ENTRIES_V
MTL_CYCLE_COUNT_HEADERS_ALL_V
MTL_CYCLE_COUNT_HEADERS_V
MTL_CYCLE_COUNT_HEADERS_VAL_V
MTL_CYCLE_COUNT_ITEMS_ALL_V
MTL_CYCLE_COUNT_ITEMS_V
MTL_DEFAULT_CATEGORY_SETS_FK_V

MTL_DEFAULT_SETS_VIEW

MTL_DEMAND_HISTORY_ITEMS_V
MTL_DEMAND_HISTORY_V
MTL_DEMAND_INTERFACE_V
MTL_DEMAND_INTERFACE_VIEW
MTL_DEMAND_OM_VIEW
MTL_DEMAND_V
MTL_DESCR_ELEMENT_VALUES_V
MTL_DESCR_ELEM_VAL_V
MTL_EAM_ASSET_ACTIVITIES_V
MTL_EAM_ASSET_ACTIVITIES_WB_V
MTL_EAM_ASSET_ATTR_GROUPS_V
MTL_EAM_ASSET_ATTR_VALUES_V
MTL_EAM_ASSET_NUMBERS_ALL_V
MTL_EAM_ASSET_NUMBERS_V
MTL_EAM_ASSET_NUM_INTERFACE_V
MTL_EAM_ASSET_REBUILDS_DTLS_V
MTL_EAM_ASSET_REBUILDS_V
MTL_EAM_EQUIP_RESOURCES_V
MTL_EAM_ITEMS_V
MTL_EAM_JOBS_RESOURCES_V
MTL_EAM_NETWORK_ASSETS_V

MTL_ECONOMIC_ZONES_VL

MTL_EMPLOYEES_CURRENT_VIEW

MTL_EMPLOYEES_VIEW
MTL_FETCH_AGREEMENT_LINES
MTL_FISCAL_CAT_ACCOUNTS_V
MTL_FORECAST_DATES_COST_V
MTL_GENEALOGY_QA_DATA
MTL_GENERIC_DISPOSITIONS_KFV
MTL_GRADES_VL
MTL_GRADE_CHANGE_ERV
MTL_GRD_STS_HISTORY_V
MTL_GROSS_REQ_COST_V

MTL_GROUP_ATPS_VIEW

MTL_GROUP_ITEM_ATPS_VIEW

MTL_INTERCOMPANY_PARAMETERS_V
MTL_INTERFACE_PROC_CONTROLS_V
MTL_INV_TXNS_MFG_LOTS_V
MTL_ITEM_ATTRIBUTES_V
MTL_ITEM_ATTRIBUTE_NAMES_V
MTL_ITEM_ATTRIBUTE_VALUES_V
MTL_ITEM_ATTR_APPL_INST_V
MTL_ITEM_ATTR_FIELDS_V
MTL_ITEM_CATALOG_GROUPS_B_KFV
MTL_ITEM_CATALOG_GROUPS_KFV
MTL_ITEM_CATALOG_GROUPS_V
MTL_ITEM_CATALOG_GROUPS_VL
MTL_ITEM_CATEGORIES_V
MTL_ITEM_CATEGORIES_VIEW
MTL_ITEM_ENDECA_CATEGORIES_V
MTL_ITEM_ENDECA_CROSS_REF_V
MTL_ITEM_ENDECA_CUSTOMERS_V
MTL_ITEM_ENDECA_DESC_ELEM_V
MTL_ITEM_ENDECA_MANF_V
MTL_ITEM_ENDECA_ONHAND_V
MTL_ITEM_ENDECA_REL_ITEMS_IV1
MTL_ITEM_ENDECA_REL_ITEMS_IV2
MTL_ITEM_ENDECA_REL_ITEMS_V
MTL_ITEM_ENDECA_REVISIONS_V
MTL_ITEM_ENDECA_SUPPLIERS_V

MTL_ITEM_FLEXFIELDS

MTL_ITEM_FLEXFIELDS_OLD
MTL_ITEM_LOCATIONS_KFV
MTL_ITEM_LOCATIONS_VIEW
MTL_ITEM_LOT_QUANTITIES_VIEW
MTL_ITEM_LOT_UOM_CONV_ERV
MTL_ITEM_ORG_CATEG_V
MTL_ITEM_ORG_REV_V
MTL_ITEM_QUANTITIES_VIEW
MTL_ITEM_REVISIONS_ALL_V
MTL_ITEM_REVISIONS_ORG_VAL_V
MTL_ITEM_REVISIONS_VL
MTL_ITEM_REV_HIGHDATE_V
MTL_ITEM_STATUS_VAL_V

MTL_ITEM_STATUS_VL

MTL_ITEM_SUB_AST_TRK_VAL_V
MTL_ITEM_SUB_AST_VAL_V
MTL_ITEM_SUB_EXP_TRK_VAL_V
MTL_ITEM_SUB_EXP_VAL_V
MTL_ITEM_SUB_INVENTORIES_ALL_V
MTL_ITEM_SUB_TRK_ALL_V
MTL_ITEM_SUB_TRK_VAL_V
MTL_ITEM_SUB_VAL_V
MTL_ITEM_TEMPLATES_ALL_V

MTL_ITEM_TEMPLATES_VL

MTL_ITEM_TEMPL_ATTRIBUTES_V

MTL_ITEM_UOMS_VIEW

MTL_KANBAN_CARDS_V
MTL_KANBAN_CARD_ACTIVITY_V
MTL_KANBAN_PULL_SEQUENCES_V

MTL_LE_ECONOMIC_ZONES_V

MTL_LOT_CONV_AUDITDETAILS_ERV
MTL_LOT_CONV_AUDIT_DETAILS_V
MTL_LOT_DEMAND_VAL_V
MTL_LOT_ISSUES_VAL_V

MTL_LOT_NUMBERS_ALL_V

MTL_LOT_NUMBERS_ERV
MTL_LOT_NUMBERS_SRW_V
MTL_LOT_NUMBERS_VAL_V
MTL_LOT_ONHAND_SUM_V

MTL_LOT_SERIAL_DFF_ERV

MTL_LOT_UOM_CLASS_CONV_V

MTL_MATERIAL_STATUSES_VL

MTL_MATERIAL_STATUS_HIST_ERV
MTL_MATERIAL_TXNS_TEMP_VIEW

MTL_MATERIAL_TXNS_VAL_V
MTL_MFG_BATCHES_SECURITY_V
MTL_MFG_BATCHES_V
MTL_MFG_COMPONENTS_V
MTL_MFG_GENEALOGY_LOTATTR_V
MTL_MFG_LOTS_TRANS_V
MTL_MFG_PART_NUMBERS_ALL_V
MTL_MFG_PRODUCTS_V

MTL_MGD_INVPOS_DATA_SETS_V

MTL_MOVEMENT_PARAMETERS_V
MTL_MOVEMENT_STATISTICS_V
MTL_MOVE_ORDER_HEADERS_V
MTL_MOVE_ORDER_LINES_V
MTL_MVT_STATS_RULE_SETS_VL
MTL_MWB_GTMP_V
MTL_NEGATIVE_VIEW
MTL_OBJECT_GRANTS_V
MTL_OBJECT_NUMBERS_V

MTL_ONHAND_ATP

MTL_ONHAND_DUMMY_V
MTL_ONHAND_ITEMS_V
MTL_ONHAND_LOCATOR_LOT_V
MTL_ONHAND_LOCATOR_V
MTL_ONHAND_LOT_V
MTL_ONHAND_LPN_MWB_V

MTL_ONHAND_LPN_V

MTL_ONHAND_NET
MTL_ONHAND_NEW_LPN_MWB_V
MTL_ONHAND_NEW_LPN_V
MTL_ONHAND_QTY_COST_V

MTL_ONHAND_QUANTITIES

MTL_ONHAND_REV_V
MTL_ONHAND_SERIAL_MWB_V
MTL_ONHAND_SERIAL_V
MTL_ONHAND_SUB_V
MTL_ONHAND_SYNC_V
MTL_ONHAND_TOTAL_MWB_V
MTL_ONHAND_TOTAL_V
MTL_OPSM_LOT_EXPORT_V
MTL_OPSM_SYSTEM_ITEMS_V
MTL_ORGANIZATIONS
MTL_ORG_ASSIGN_V
MTL_ORG_REPORT_TEMP_FK_V
MTL_PAC_TXN_COST_DETAILS_V
MTL_PARAMETERS_ALL_V
MTL_PARAMETERS_VIEW
MTL_PENDING_TXNS_MFG_LOTS_V
MTL_PENDING_TXN_DETAILS_V
MTL_PERIODS
MTL_PERIOD_SUMMARY_V
MTL_PHYSICAL_ADJUSTMENTS_V
MTL_PHYSICAL_ADJUSTMENTS_VIEW

MTL_PHYSICAL_INVENTORIES_V

MTL_PHYSICAL_INVENTORY_TAGS_V

MTL_PHYSICAL_SUBINVENTORIES_V
MTL_PHY_ADJ_COST_V
MTL_PHY_INV_TAGS_COST_V
MTL_PRIMARY_UOMS_VV

MTL_PROCURING_TXN_FLOW_HDRS_V

MTL_PROCURING_TXN_FLOW_LINES_V

MTL_PROJECT_DEMAND_VIEW
MTL_PROJECT_V
MTL_QOH_ITEM_ALL_V
MTL_QOH_ITEM_V
MTL_QOH_LOCATOR_V
MTL_QOH_LOC_ALL_V
MTL_QOH_LOT_ALL_V
MTL_QOH_LOT_V
MTL_QOH_REV_ALL_V
MTL_QOH_REV_V
MTL_QOH_SUB_ALL_V
MTL_QOH_SUB_V
MTL_RCV_MWB_NEW_OH_V

MTL_RCV_MWB_ONHAND_V
MTL_RCV_SERIAL_MWB_OH_V

MTL_RCV_SERIAL_OH_V

MTL_RELATED_ITEMS_ALL_V
MTL_RELATED_ITEMS_CUST_REF_V
MTL_RELATED_ITEMS_PLN_INFO_V

MTL_RELATED_ITEMS_VIEW

MTL_REPLENISH_HEADERS_VIEW
MTL_REPLENISH_LINES_VIEW
MTL_RESERVATIONS_ALL_V
MTL_RESERVATIONS_INTERFACE_V
MTL_RESERVATIONS_V
MTL_RESERVATIONS_VIEW
MTL_ROUTING_REV_HIGHDATE_V
MTL_SAFETY_STOCKS_VIEW
MTL_SALES_ORDERS_KFV
MTL_SECINV_QUANTITIES_VIEW
MTL_SECONDARY_INVENTORIES_FK_V
MTL_SECONDARY_LOCATORS_ALL_V
MTL_SERIAL_NUMBERS_ALL_V
MTL_SERIAL_NUMBERS_SRW_V
MTL_SERIAL_NUMBERS_TEMP_ERV
MTL_SERIAL_NUMBERS_VAL_V
MTL_SERIAL_NUMBER_GEN_V
MTL_SERVICE_CONTRACTS_V
MTL_SHIPPING_NETWORK_VIEW
MTL_SHORT_SUMMARY_V
MTL_STATUS_CONTROL_V
MTL_STAT_ATTRIB_VALUES_ALL_V

MTL_STAT_TYPE_USAGES_V

MTL_SUBINVENTORIES_ALL_V
MTL_SUBINVENTORIES_TRK_VAL_V
MTL_SUBINVENTORIES_VAL_V
MTL_SUB_AST_TRK_VAL_V
MTL_SUB_AST_VAL_V
MTL_SUB_EXP_TRK_VAL_V
MTL_SUB_EXP_VAL_V
MTL_SUB_TRK_ALL_V
MTL_SUMMARY_TEMP_V
MTL_SUPPLIER_SITES_V
MTL_SYSTEM_ITEMS_B_KFV
MTL_SYSTEM_ITEMS_ER1_V

MTL_SYSTEM_ITEMS_ER2_V

MTL_SYSTEM_ITEMS_ER3_V

MTL_SYSTEM_ITEMS_ER4_V

MTL_SYSTEM_ITEMS_FKEYS_V

MTL_SYSTEM_ITEMS_FVL

MTL_SYSTEM_ITEMS_VL

MTL_TASK_V
MTL_TRANSACTIONS_INTERFACE_V
MTL_TRANSACTIONS_TEMP_ALL_V
MTL_TRANSACTION_DETAILS_V

MTL_TRANSACTION_FLOWS_V

MTL_TRANSACTION_FLOW_HEADERS_V

MTL_TRANSACTION_FLOW_LINES_V

MTL_TRANSACTION_LOTS_TEMP_V
MTL_TRANSACTION_LOTS_VIEW
MTL_TRANSACTION_LOT_VAL_V
MTL_TRANSACTION_REASONS_ALL_V
MTL_TRANSACTION_REASONS_VAL_V
MTL_TRANSACT_INTERFACE_VIEW
MTL_TRAN_TYPES_SYS_VAL_VIEW
MTL_TRAN_TYPES_USER_VAL_VIEW
MTL_TRX_TYPES_VIEW
MTL_TXN_BACKORDERS_V
MTL_TXN_REQUEST_HEADERS_V
MTL_TXN_REQUEST_LINES_V
MTL_TXN_SOURCE_TYPES_ALL_V
MTL_TXN_SRC_FOR_TRAN_TYPE_VIEW
MTL_UNITS_OF_MEASURE_AV

MTL_UNITS_OF_MEASURE_VL

MTL_UNITS_OF_MEASURE_VV
MTL_UNIT_TRANSACTIONS_ALL_V
MTL_UOM_CLASSES_AV
MTL_UOM_CLASSES_VL
MTL_UOM_CLASSES_VV
MTL_UOM_CLASS_CONV_VAL_V
MTL_UOM_CONVERSIONS_VAL_V

MTL_UOM_CONVERSIONS_VIEW

MTL_VENDOR_LOT_VIEW
MTL_WORK_ORDER_HEADER_V
ORG_ACCESS_V

ORG_ACCESS_VIEW

ORG_ACCT_PERIODS_V
ORG_ENABLED_FREIGHT_VAL_V
ORG_FREIGHT_CODE_ALL_V
ORG_FREIGHT_CODE_VAL_V
ORG_FREIGHT_VL
ORG_GL_BATCHES_V
ORG_ORGANIZATION_DEFINITIONS

ORG_ORGANIZATION_DEFINITIONS2

ORG_ORGANIZATION_DEF_MRC_V
ORG_ORG_DEFINITIONS_ALL_V
RCV_RECEIPT_CONFIRMATION_V
DESCRIPTION

Cost error table

This table will be used as basis for capacity calculation seeded source in
3PL Billing Solution
Assigns abc classes to abc groups
Defines abc groups
Assigns items to abc classes in an abc group
Inventory ABC classes
ABC compile header data
Euro as a Functional Currency Archive
ABC descending value compile data
Euro as a Functional Currency Archive
Action Codes
Action Codes Language Translation
Stores the material overhead subelements
Euro as a Functional Currency Archive

ATP computation rules

Dependencies between item attributes and Oracle products

Base table for 3PL Billing Rules definitions

Translation table for 3PL billing rule header table
Billing Rule Lines table for 3PL Billing Project.

Base Table for Billing sources required in 3PL Billing project

MTL_BILLING_SOURCES_TL is the translation table for the billing

sources
BIS table that stores inventory turns data by organization, accounting
period and Inventory item id for open periods and closed periods

Items returned by item searches

Code combinations table for Item Category
Categories table storing translated Description column for Item
Categories

Asset and expense accounts by item category, by subinventory

Valid categories for category sets

Category Sets
A table holding translated Name and Description columns for Category
Sets
Cycle Count Entries Interface data
Cycle Count Entries Interface process errors
Cross references count entry requests
Defines cycle count schedule requests
Serial Numbers for Cycle Count Entries.

Defines subinventories to be used in subinventory level cycle count

Child Lot Number Sequences

Customer Items Interface
Customer Items Cross References Interface
Client Parameters table

Customer item commodity codes

This table contains the results of the Consigned inventory diagnostics
concurrent program.
This table stores set up records for  consumption rules of  consigned
inventory

MTL_CONSUMPTION_TRANSACTIONS contains information

related to the change of ownership transactions that have occurred to
your consigned inventory. The table is used by the "Create Consumption
Advice" concurrent program.  Each consumption adv

Interface Table for the Copy Inventory Organizations Concurrent

Program. The GROUP_CODE column is used in Copy Inventory
Organizations Standard Concurrent Request to identify a set of rows that
describe the organizations to be generated by 

This private table contains temporary data to construct a Copy Inventory

Organization Report. It is populated by a java session and read by
Oracle Reports during a single concurrent request; it will only contain
data while the request is ru

 stores information concerning the assignment of countries to economic

zones.
Define cross reference types
Assign cross references to items
Assign cross references to items
(not currently used)

Cross Reference table storing translated Description column

Euro as a Functional Currency Archive

Actual cost information by element and by level
Actual cost information by element, by level
The cost of a transaction by element and by level
Euro as a Functional Currency Archive
Relationships between customer items and inventory items
Customer item Information
Defines cycle count classes
Euro as a Functional Currency Archive
Defines cycle count entries
Euro as a Functional Currency Archive
Defines cycle count header information
Euro as a Functional Currency Archive
Defines items to be used in cycle count
Default category set for a particular functional area
Sales order demand and reservations
Sales order demand and reservations
Temporary demand storage for the transaction processor
Not used currently
Stores the descriptive element values for a particular item
Descriptive element definitions for an item catalog group
Table for Asset Activity Association
Table for asset attribute groups
Table for asset attribute values
Asset Number Interface table
Temporary table for Asset Search
Asset Attribute Interface table
Table for EAM area
Table for association of assets to asset route.
Stores information concerning all the economic zones.

Corresponding transalation table for MTL_ECONOMIC_ZONES_B.

External component information of an inventory item

Category account definitions for legal entity
Context mapping table for Lot & Serial attributes Descriptive Flex
Fields.
Forecast rules for forecast processes

Account alias definition

Grade Codes
Grade Codes Language Translation

Recommended item aliases for items in an item catalog group

Recommended item categories for items in an item catalog group

Inter-company relationships
Item open interface errors
Interface Processes Control Parameters
Inter-organization relationships

Relationships between shipping networks and shipment methods

Inventory Packing slip documents.

Inventory Picking rules
Item attributes table
MTL_ITEM_ATTRIBUTES_SEED_INFO contains the seed attributes
information to be  used specifically in the copy item attributes user
interface module.

Item Bulkloaded Records

Item Catalog Groups

Item Catalog Groups table storing translated Description column

Define item assignments to categories

Item Category Open Interface table; used to load item assignments to

category sets and categories into Oracle Inventory.

Not currently used

Inventory item receiving and shipping locator default values

Definitions for stock locators
Item revisions
Item Revisions interface
Item Revisions table storing translated Description column
Material status definitions
Material status definitions

Inventory item receiving and shipping subinventory default values

Item-subinventory assignments
(currently not used)
Item attributes and attribute values for a template
Item template definitions
Item template definitions
MTL_ITEM_TEMPLATES_TL is a table holding translated Template
and Description columns for Templates. Templates now support
multilingual description. MLS is implemented with a pair of tables:
MTL_ITEM_TEMPLATES_B and MTL_ITEM_TEMPLATES_TL. Tr

Holds Item Attributes and their values. Used in the Item Attributes
Copyform.
Kanban Card Activity
Temporary table used to print kanban cards
Kanban Cards
Kanban Pull Sequences
Kanban Template
stores information concerning the assignment of legal entity to
economic zones.
Audit Trail for conversion changes
Audit Detail Record

New Table, stores the grade update history lot grade updates.

Lot number definitions

Lot specific conversions

Onhand Xml
Define manufacturers
Inventory status update history - Used by WMS only
Inventory status definition   - Used by WMS only

Base table for inventory status definitions - Used by WMS only

Translation table for inventory status definition - Used by WMS only

Material transaction table

Euro as a Functional Currency Archive
Temporary table for processing material transactions
Unit allocations among repetitive schedules
Define manufacturer part numbers
Stores the data sets built for on line display or for export
this table will store information about user logging  history
Back up table for Inventory onhand
Movement parameter values

Stores all relevant information  for movement statistics transactions.

Euro as a Functional Currency Archive

Movement Statistics table to store Rule Sets for validation rules.

MTL_MVT_STATS_RULE_SET_TL is the corresponding transalation
table for MTL_MVT_STATS_RULE_SET_B.This table contains one
entry for every Rule Set Code and Language.Rule Set Code and 
Language uniquely identify a row.Rule Set Display Name iden

This table stores validation rules defined for movement statistics fields
that belong to a rule set as defined in
MTL_MVT_STATS_RULE_SETS_B table.Each row stores a rule that
can determine a  valid set of values for a field or an alternate u

Major events that have occurred relevant to an object

Genealogy information between an object and its parents
Object Genealogy Inteface table

FIFO quantities by control level and receipt

FIFO quantities by control level and receipt
Temporary table for on-hand quantity queries
Multi-organization inventory report temporary table

Used to temporarily hold data during the interorg iteration process

Euro as a Functional Currency Archive

Stores the elemental cost for a given transaction in a period
Stores the material overhead sub-elements that are charged for a given
transaction in a particular period.
Euro as a Functional Currency Archive
Transaction details for a period
Euro as a Functional Currency Archive
Inventory control options and defaults
History of item-status assignments
Inventory Period Close Details
Euro as a Functional Currency Archive

The table contains summarized inventory valuation details for an

accounting period, organization, inventory type and cost group

Period summary inventory values for subinventories

Euro as a Functional Currency Archive
Physical inventory adjustments
Euro as a Functional Currency Archive
Physical inventory definitions
Euro as a Functional Currency Archive
Physical inventory tag definitions
Physical inventory specific subinventories
This table is used by parallel pick release
Picking Rule Definitions
Planner code definitions
This table contains the Purchasing packing slips information. It is used
by  the purhjasing packing slip report

Transaction history purges

(not currently used)
(not currently used)
(not currently used)
(not currently used)
(not currently used)
Item Relationships
Item Relationships Customer References
Not currently used
Item Relationships Planning Information
Replenishment header information
Replenishment header interface information
Replenishment line information
Replenishment line interface information
Reservations
Reservations Interface

Routing revisions
Routing revisions interface table
Safety stocks
Local definitions of sales orders
Seasonality indices
Subinventory definitions
Item-subinventory-locator assignments
(not currently used)
Serial number definitions

Temporary serial number storage for transactions processor

Temporary serial number holding table

Shortage Parameters
Shortage Check Statements
Shortage Check Temporary Table

THIS TABLE IS OBSOLETE WITH THE NEW ORDER

MANAGEMENT SYSTEM. IT IS USED ONLY FOR DATA
MIGRATION FROM THIS TABLE TO THE NEW ORDER
MANAGEMENT SYSTEM. .RMA headers and lines for OE interface
THIS TABLE IS OBSOLETE WITH THE NEW ORDER
MANAGEMENT SYSTEM. IT IS USED ONLY FOR DATA
MIGRATION FROM THIS TABLE TO THE NEW ORDER
MANAGEMENT SYSTEM. RMA receipt transactions
Stores information which determines the statistical type data  for each
legal entity.
Item status code attribute values
Relations between inventory status and transaction type  - Used by
WMS only

Transaction summaries
Stores incoming supply information

Temporary table containing ATP details returned from ATP user-exit

Inventory item definitions

Euro as a Functional Currency Archive
Inventory Items Open Interface table

Translations table table holding item descriptions in multiple languages

Table MTL_TRANS_REASON_SECURITY, includes the items details

for Regulatory Items with regard to the Convergence model

Material transaction distributions

Euro as a Functional Currency Archive
Intercompany Transaction Flow
Inter-company Transaction flow lines
Transaction lot numbers
Temporary lot storage for transaction processor
Temporary lot numbers holding table
Inventory Transaction Reasons Table
Inventory Transaction Types Table
Gateway for externally generated material transactions

Stores transaction cost by element and by level for transactions to be

imported through the transaction  interface

Move Order headers table

Move order lines table
Valid transaction source types

Serial number transactions

Unit of measure definitions
Conversions between base units of two different classes
Unit of measure classes
Unit of measure conversion table for both default and item specific
conversions
Used exclusively for the item attribute copy form
External demand information to be considered in ATP
External supply information to be considered in ATP

Organization access rules table

Organization accounting period definition table
Freight codes
General Ledger transfer information for each batch

DESCRIPTION

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted

 - Retrofitted
 - Retrofitted

 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted

 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted

Cost for Inventory  Items with standard cost, and items with average
cost using
Supply Chain Inventory Information
View of Lot and Serial Descriptive Flex Field Column
View of Lot and Serial Descriptive Flex Field Context

MFG_LOOKUPS is a view of selected columns from the table

FND_LOOKUP_VALUES.
MFG_LOOKUPS_V is a view of selected columns from the table
FND_LOOKUP_VALUES.
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
 - Retrofitted
 - Retrofitted
Actions Code View
10SC ONLY
No longer used
View of select available inventory

Stores Onhand/Intransit quantity and value for Inventory items at

organization and intransit owning organizations respectively.

10SC ONLY
Categories Key Flexfield View
10SC ONLY
Categories multilingual view
 - Retrofitted

Provides information regarding parties and roles on categories

10SC ONLY
10SC ONLY
Category Sets multilingual view
10SC ONLY
Cycle Count Entries Interface View
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
Cycle Count Entries Interface Errors View
10SC ONLY
10SC ONLY

10SC ONLY
10SC ONLY
For Consumption setup  forms
View joins territories and country assignments
10SC ONLY
10SC ONLY

This table contains the columns of MTL_CROSS_REFERENCES_B

and MTL_CROSS_REFERENCES_TL for current user's language
settings
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
Required to get around SRS's 240 char limit when defaulting category
sets
10SC ONLY
10SC ONLY
10SC ONLY
A view for demand interface table.

10SC ONLY
10SC ONLY
10SC ONLY
View for Asset Activities
View for Activity Workbench
View for Asset Attribute Groups
View for Asset Attribute Values
View for Asset Number details
View for Asset Numbers
Asset Number Interface View
View shows the details of Assets and Rebuilds.
View for Asset and Rebuild information.
View for EAM equipment resources
View of all EAM items.
Job resources for EAM (Enterprise Asset management)
View for EAM Asset Routes

Joins the base economic zone table and translated economic zone table

View of employees currently assigned to a given organization

View of employees

PAC Category Accounts

 - Retrofitted
Account Alias Key Flexfield View
Grade Code View

 - Retrofitted
This view is used for ATP and derived from
MTL_DEMAND_INTERFACE
This view is used for ATP and derived from
MTL_DEMAND_INTERFACE
10SC ONLY
10SC ONLY

10SC ONLY
10SC ONLY
10SC ONLY

10SC ONLY
Item Catalog Groups dummy key flexfield view
Item Catalog Key Flexfield View
10SC ONLY
Item Catalog Groups multilingual view
10SC ONLY
10SC ONLY

This view is based on the key flexfield view

MTL_SYSTEM_ITEMS_B_KFV.  It contains columns with padded
and unpadded concatenated segments of an item number.

Contains concatenated item segments, inventory_item_id

Item Locations Key Flexfield View
View of item quantities by locator
Item lot quantities under subinventory and locator

10SC ONLY
10SC ONLY
Item onhand quantities view
10SC ONLY
10SC ONLY
Item Revisions multilingual view
10SC ONLY
10SC ONLY
This table contains the columns of MTL_ITEM_STATUS_TL a for
current user's language settings
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY
 - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY

This table contains the columns of MTL_ITEM_TEMPLATES_B and

MTL_ITEM_TEMPLATES_TL for current user's language settings

10SC ONLY
Holds valid UOMs for items, considering the conversions that are
defined
 - Retrofitted
 - Retrofitted
retrofitted
Join between the table MTL_Le_Economic_Zones, the view
MTL_Economic_Zones_VL and HR_Legal_Entities

Lot Specific UOM Conversions Audit Details

10SC ONLY

10SC ONLYCHANGES DONE AS VIEW IS NON MERGEABLE

DUE TO JOIN ON MTL_MATERIAL_STATUSES_VL

10SC ONLY
10SC ONLY
Quantity view for Lot uom conversion use
Required for electronic records.  Selects the lot and serial attributes out
of the description flexfield data model.
Lot Specific UOM Conversions

Multilingual view for material status tables. - Used by WMS only

A View of MTL_MATERIAL_TRANSACTIONS_TEMP used in an
Inquiry form
 - Retrofitted
View of gme batches with securities for genealogy
View of gme batches for Genealogy

10SC ONLY

This view lists the names of the existing data sets created by  the
Inventory Position View feature.
10SC ONLY

 - Retrofitted
 - Retrofitted
Multilingual view for Rule Sets tables.
Material Workbench Global Temporary Table View
View of onhand negative inventory

View of the genealogy object numbers

This view would be used by Planning to calculate the ATPable quantity
for an item.

10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
LPN content view for Material Workbench
This view contains information about packed material that resides in
LPNs.

LPN content view for Material Workbench

LPN content view
 - Retrofitted
View of items owned, planned and physically belonging to the same
inventory organization
10SC ONLY
Onhand Serial View for the Material Work Bench

10SC ONLY

Onhand Total View for the Material Work Bench

View of organizations
10SC ONLY
10SC ONLY

 - Retrofitted
 - Retrofitted

View of period dates and inventory value for open periods

10SC ONLY
10SC ONLY
Physical inventory adjustments created by Item Counts.
View based on table MTL_PHYSICAL_INVENTORIES. Has all the
Physical Inventory Setup Information.
View based on table MTL_PHYSICAL_INVENTORY_TAGS. Has
information for all the Physical Inventory tags.
10SC ONLY
 - Retrofitted
 - Retrofitted
10SC ONLY
MTL_PROCURING_TXN_FLOW_HDRS_V is a view of transaction
flow headres for procuring flow.

MTL_PROCURING_TXN_FLOW_LINES_V is a view for transaction

flow lines of type procuring. This view is used by Oracle Procuring to
query the transaction flow lines information for each header.

 - Retrofitted
 - Retrofitted
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY

MTL_RCV_MWB_ONHAND_V is used in the material workbench to

query the on-hand quantities of materials that are in receiving.
MTL_RCV_SERIAL_MWB_OH_V is a new view which needs to be
used for querying data when the user chooses subinventory type of
Receiving and user has entered serials and grade code in the Find
window, or has entered grade in the Find window and 

MTL_RCV_SERIAL_OH_V is used in the material workbench to query

the on-hand quantities of materials that are in receiving and are serial
controlled.
10SC ONLY

View of MTL_RELATED_ITEMS with reciprocal item relationships

appearing twice
 - Retrofitted
 - Retrofitted

10SC ONLY
Not used
10SC ONLY
 - Retrofitted
Sales Orders Key Flexfield View
View of Item subinventory
 - Retrofitted
10SC ONLY
10SC ONLY
10SC ONLY
Required by electronic records to snapshot serial numbers.
10SC ONLY

 - Retrofitted
Summary view of the material shortages temp table

10SC ONLY
Join of Stat_Type_Usages, Hr Legal Entities, Category Sets, Economic
Zones View and Hr Locations
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
 - Retrofitted
10SC ONLY
 - Retrofitted
System Items Key  Flexfield View
ERES : View to support ERES framework for Items
ERES : View to support ERES framework for Items Catalog Group
Assignment
ERES : View to support ERES framework for Items Catalog Group
Assignment(Summary View)
ERES : View to support ERES framework for Items Organization
Assignment
10SC ONLY
Base view for the Define System Items (INVIDITM) form
MTL_SYSTEM_ITEMS block.  This view is MLS enabled.

System Items multilingual view with concatenated segments column

 - Retrofitted
 - Retrofitted
 - Retrofitted

MTL_TRANSACTION_FLOWS_V is a view for Intercompany

transaction flows of type shipping and procuring flows.
MTL_TRANSACTION_FLOW_HEADERS_V is a view for
Intercompany transaction flow headers of type shipping and procuring
flows.
MTL_TRANSACTION_FLOW_LINES_V is a view for Intercompany
transaction flow lines of type shipping and procuring flow for each
header.

A view showing all material lot number transactions.

10SC ONLY
10SC ONLY
10SC ONLY
Transaction interface status view
 - Retrofitted
 - Retrofitted
 - Retrofitted

10SC ONLY
 - Retrofitted
10SC ONLY
MTL_UNITS_OF_MEASURE_VL  is a view of selected columns from
the table MTL_UNITS_OF_MEASURE_TL.
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
10SC ONLY
View giving unit of measure conversion rates between the primary unit
of measure and another unit of measure
Supplier information

10SC ONLY
Organization access view resolving all organizations available for each
responsibility
10SC ONLY
 - Retrofitted
10SC ONLY
10SC ONLY

10SC ONLY
Inventory organizations

Inventory organizations and organizations "claiming" to be inventory

organizations but do not have inventory parameters

 - Retrofitted
10SC ONLY