You are browsing the archive for RCV.

Purchasing Intelligence Tables

Oracle Purchasing Intelligence Tables:

  • EDW_DUNS_A_LTC
  • EDW_DUNS_DOMESTIC_LSTG
  • EDW_DUNS_DOMESTIC_LTC
  • EDW_DUNS_GLOBAL_LSTG
  • EDW_DUNS_GLOBAL_LTC
  • EDW_DUNS_HEADQTR_LSTG
  • EDW_DUNS_HEADQTR_LTC
  • EDW_DUNS_M
  • EDW_DUNS_NUMBER_LSTG
  • EDW_DUNS_NUMBER_LTC
  • EDW_DUNS_PARENT_LSTG
  • EDW_DUNS_PARENT_LTC
  • EDW_GEOGRAPHY_A_LTC
  • EDW_GEOGRAPHY_M
  • EDW_GEOG_AREA1_LSTG
  • EDW_GEOG_AREA1_LTC
  • EDW_GEOG_AREA2_LSTG
  • EDW_GEOG_AREA2_LTC
  • EDW_GEOG_CITY_LSTG
  • EDW_GEOG_CITY_LTC
  • EDW_GEOG_COUNTRY_LSTG
  • EDW_GEOG_COUNTRY_LTC
  • EDW_GEOG_LOCATION_LSTG
  • EDW_GEOG_LOCATION_LTC
  • EDW_GEOG_POSTCODE_CITY_LSTG
  • EDW_GEOG_POSTCODE_CITY_LTC
  • EDW_GEOG_POSTCODE_LSTG
  • EDW_GEOG_POSTCODE_LTC
  • EDW_GEOG_REGION_LSTG
  • EDW_GEOG_REGION_LTC
  • EDW_GEOG_STATE_LSTG
  • EDW_GEOG_STATE_LTC
  • EDW_GEOG_STATE_REGION_LSTG
  • EDW_GEOG_STATE_REGION_LTC
  • EDW_LKUP_LOOKUP_CODE_LSTG
  • EDW_LKUP_LOOKUP_CODE_LTC
  • EDW_LOOKUP_A_LTC
  • EDW_LOOKUP_M
  • EDW_POA_LNTP_LN_TYPE_LSTG
  • EDW_POA_LNTP_LN_TYPE_LTC
  • EDW_POA_LN_TYPE_A_LTC
  • EDW_POA_LN_TYPE_M
  • EDW_POA_SPIM_SPLRITEM_LSTG
  • EDW_POA_SPIM_SPLRITEM_LTC
  • EDW_POA_SPLRITEM_A_LTC
  • EDW_POA_SPLRITEM_M
  • EDW_SPSC_CLASS_LSTG
  • EDW_SPSC_CLASS_LTC
  • EDW_SPSC_COMMODITY_LSTG
  • EDW_SPSC_COMMODITY_LTC
  • EDW_SPSC_FAMILY_LSTG
  • EDW_SPSC_FAMILY_LTC
  • EDW_SPSC_FUNCTION_LSTG
  • EDW_SPSC_FUNCTION_LTC
  • EDW_SPSC_SEGMENT_LSTG
  • EDW_SPSC_SEGMENT_LTC
  • EDW_TPRT_P1_TPARTNER_LSTG
  • EDW_TPRT_P1_TPARTNER_LTC
  • EDW_TPRT_P2_TPARTNER_LSTG
  • EDW_TPRT_P2_TPARTNER_LTC
  • EDW_TPRT_P3_TPARTNER_LSTG
  • EDW_TPRT_P3_TPARTNER_LTC
  • EDW_TPRT_P4_TPARTNER_LSTG
  • EDW_TPRT_P4_TPARTNER_LTC
  • EDW_TPRT_TPARTNER_LOC_LSTG
  • EDW_TPRT_TPARTNER_LOC_LTC
  • EDW_TPRT_TRADE_PARTNER_LSTG
  • EDW_TPRT_TRADE_PARTNER_LTC
  • EDW_TRD_PARTNER_A_LTC
  • EDW_TRD_PARTNER_M
  • EDW_UNSPSC_A_LTC
  • EDW_UNSPSC_M
  • POA_DNB_ITEMS
  • POA_DNB_SIC_CODE
  • POA_DNB_TRD_PRTNR
  • POA_EDW_ALINES_F
  • POA_EDW_ALINES_FSTG
  • POA_EDW_CONTRACT_F
  • POA_EDW_CONTRACT_FSTG
  • POA_EDW_CSTM_MSR_F
  • POA_EDW_CSTM_MSR_FSTG
  • POA_EDW_PO_DIST_F
  • POA_EDW_PO_DIST_FSTG
  • POA_EDW_PO_DIST_INC
  • POA_EDW_RCV_TXNS_F
  • POA_EDW_RCV_TXNS_FSTG
  • POA_EDW_RCV_TXNS_INC
  • POA_EDW_SUP_PERF_F
  • POA_EDW_SUP_PERF_FSTG
  • POA_EDW_SUP_PERF_INC
  • POA_TPRT_INTERFACE
  • POA_UNSPSC_INTERFACE
EDW_PO_VENDOR_HIERARCHIES
FND_FUNCTION_PARAMETER_MAP
FND_NOTIFICATIONS
POA_BIS_SAVINGS
POA_BIS_SAVINGS_EFC
POA_BIS_SAVINGS_RPT
POA_BIS_SAVINGS_RPT_EFC
POA_BIS_SUPPLIER_PERFORMANCE
POA_BIS_SUPPLIER_PERFORMAN_EFC
POA_CM_DISTRIBUTIONS
POA_CM_EVALUATION
POA_CM_EVAL_SCORES
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_ASL_ATTRIBUTES
PO_ASL_DOCUMENTS
PO_ASL_STATUSES
PO_ASL_STATUS_RULES
PO_ATT_TMP_RECORDS
PO_AUTOSOURCE_DOCUMENTS_ALL
PO_AUTOSOURCE_RULES
PO_AUTOSOURCE_VENDORS
PO_CHANGE_REQUESTS
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_DISTRIBUTIONS_ALL
PO_DISTRIBUTIONS_ALL_EBS
PO_DISTRIBUTIONS_ARCHIVE_ALL
PO_DISTRIBUTIONS_INTERFACE
PO_DOCUMENT_TOTALS_GT
PO_DOCUMENT_TYPES_ALL_B
PO_DOCUMENT_TYPES_ALL_TL
PO_EMPLOYEE_HIERARCHIES_ALL
PO_ENCUMBRANCE_GT
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_ARCHIVE_ALL
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_LINES_ALL
PO_LINES_ALL_EBS
PO_LINES_ARCHIVE_ALL
PO_LINES_INTERFACE
PO_LINE_LOCATIONS_ALL
PO_LINE_LOCATIONS_ALL_EBS
PO_LINE_LOCATIONS_ARCHIVE_ALL
PO_LINE_LOCATIONS_GT
PO_LINE_TYPES_B
PO_LINE_TYPES_TL
PO_LOCATION_ASSOCIATIONS
PO_LOCATION_ASSOCIATIONS_ALL
PO_MASSCANCEL_INCLUDES_ALL
PO_MASSCANCEL_INTERIM
PO_MC_DISTRIBUTIONS
PO_MC_HEADERS
PO_NOTES
PO_NOTE_ATTRIBUTES
PO_NOTE_REFERENCES
PO_NOTIFICATIONS_ALL
PO_NOTIFICATION_CONTROLS
PO_ONLINE_REPORT_TEXT
PO_POSITION_CONTROLS_ALL
PO_PRICE_DIFFERENTIALS
PO_PRICE_DIFFERENTIALS_ARCHIVE
PO_PRICE_DIFF_INTERFACE
PO_PURGE_PO_LIST
PO_PURGE_RECEIPT_LIST
PO_PURGE_REQ_LIST
PO_PURGE_VENDOR_LIST
PO_QUALITY_CODES
PO_QUOTATION_APPROVALS_ALL
PO_RELATED_TEMPLATES
PO_RELEASES_ALL
PO_RELEASES_ALL_EBS
PO_RELEASES_ARCHIVE_ALL
PO_REQEXPRESS_HEADERS_ALL
PO_REQEXPRESS_LINES_ALL
PO_REQUISITIONS_INTERFACE_ALL
PO_REQUISITIONS_INT_ALL_EFC
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES_ALL
PO_REQUISITION_LINES_ALL_EFC
PO_REQUISITION_SUPPLIERS
PO_REQ_DISTRIBUTIONS_ALL
PO_REQ_DISTRIBUTIONS_ALL_EFC
PO_REQ_DIST_INTERFACE_ALL
PO_RESCHEDULE_INTERFACE
PO_RETRIEVED_TIMECARDS
PO_RFQ_VENDORS
PO_RULE_EXPENSE_ACCOUNTS
PO_SUPPLIER_ITEM_CAPACITY
PO_SUPPLIER_ITEM_TOLERANCE
PO_SYSTEM_PARAMETERS_ALL
PO_UNIQUE_IDENTIFIER_CONT_ALL
PO_UN_NUMBERS_B
PO_UN_NUMBERS_TL
PO_USAGES
PO_USAGE_ATTRIBUTES
PO_VALIDATION_RESULTS_GT
PO_VENDORS
PO_VENDORS_EBS
PO_VENDOR_CONTACTS
PO_VENDOR_LIST_ENTRIES
PO_VENDOR_LIST_HEADERS
PO_VENDOR_SITES_ALL
PO_VENDOR_SITES_ALL_EBS
PO_WF_CANDIDATE_REQ_LINES_TEMP
PO_WF_DEBUG
PO_WF_USER_TMP
RCV_ACCOUNTING_EVENTS
RCV_ACCOUNTING_EVENT_TYPES
RCV_FTE_TRANSACTION_LINES
RCV_GAPLESS_INVOICE_NUMBERS
RCV_HEADERS_INTERFACE
RCV_LOTS_INTERFACE
RCV_LOTS_SUPPLY
RCV_LOT_TRANSACTIONS
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_SERIALS_INTERFACE
RCV_SERIALS_SUPPLY
RCV_SERIAL_TRANSACTIONS
RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_SHIPMENT_LINES_EFC
RCV_SUB_LEDGER_DETAILS
RCV_SUPPLY
RCV_TRANSACTIONS
RCV_TRANSACTIONS_INTERFACE
RCV_UPGRADE_STEPS

Purchasing Descriptive Flex Fields

Oracle Purchasing Descriptive module Flex Fields:

DFF View DFF CODE NAME DFF name
PO_ACCEPTANCES_DFV PO_ACCEPTANCES Acceptances
PO_AGENTS_DFV PO_AGENTS Purchasing Agents
PO_APPROVED_SUPPLIER_LIST_DFV PO_APPROVED_SUPPLIER_LIST Approved Supplier List
PO_ASL_ATTRIBUTES_DFV PO_ASL_ATTRIBUTES Attributes
PO_ASL_DOCUMENTS_DFV PO_ASL_DOCUMENTS Documents
PO_ASL_STATUSES_DFV PO_ASL_STATUSES Statuses
PO_AUTOSOURCE_DOCUMENTS_AL_DFV PO_AUTOSOURCE_DOCUMENTS PO Autosource Documents
PO_AUTOSOURCE_RULES_DFV PO_AUTOSOURCE_RULES PO Autosource Rules
PO_AUTOSOURCE_VENDORS_DFV PO_AUTOSOURCE_VENDORS PO Autosource Vendors
PO_CONTROL_FUNCTIONS_DFV PO_CONTROL_FUNCTIONS Purchasing Control Functions
PO_CONTROL_GROUPS_ALL_DFV PO_CONTROL_GROUPS Purchasing Control Groups
PO_CONTROL_RULES_DFV PO_CONTROL_RULES Purchasing Control Rules
PO_DISTRIBUTIONS_ALL_DFV PO_DISTRIBUTIONS PO Distributions
PO_DISTRIBUTIONS_ARCHIVE_A_DFV PO_DISTRIBUTIONS_ARCHIVE PO Distributions Archive
PO_DOCUMENT_TYPES_ALL_B_DFV PO_DOCUMENT_TYPES Document Type Definitions
PO_HAZARD_CLASSES_B_DFV PO_HAZARD_CLASSES Hazard Classes
PO_HEADERS_ALL_DFV PO_HEADERS PO Headers
PO_HEADERS_ARCHIVE_ALL_DFV PO_HEADERS_ARCHIVE PO Headers Archive
PO_HISTORY_REQUISITIONS_AL_DFV PO_HISTORY_REQUISITIONS PO History Requisitions
PO_LINES_ALL_DFV PO_LINES PO Lines
PO_LINES_ARCHIVE_ALL_DFV PO_LINES_ARCHIVE PO Lines Archive
PO_LINE_LOCATIONS_ALL_DFV PO_LINE_LOCATIONS PO Line Locations
PO_LINE_LOCATIONS_ARCHIVE__DFV PO_LINE_LOCATIONS_ARCHIVE PO Line Locations Archive
PO_LINE_TYPES_B_DFV PO_LINE_TYPES PO Line Types
PO_LOCATION_ASSOCIATIONS_A_DFV PO_LOCATION_ASSOCIATIONS PO Location Associations
PO_NOTE_REFERENCES_DFV PO_NOTE_REFERENCES PO Note References
PO_NOTIFICATION_CONTROLS_DFV PO_NOTIFICATION_CONTROLS PO Notification Controls
PO_REQEXPRESS_LINES_ALL_DFV PO_PDF_EXP_LINES_SOURCE_VENDOR ReqExpress Vendor Source
PO_DISTRIBUTIONS_ALL1_DFV PO_PDF_PO_DISTRIBS_DESTINATION Purchase Order Destination Details
PO_DISTRIBUTIONS_ALL2_DFV PO_PDF_PO_PROJECT_ACCOUNTING Purchase Order Project Information
PO_REQUISITION_LINES_ALL_DFV PO_PDF_REQ_LINES_DESTINATION Destination
PO_REQUISITION_LINES_ALL1_DFV PO_PDF_REQ_LINES_SOURCE_INV Inventory Source
PO_REQUISITION_LINES_ALL2_DFV PO_PDF_REQ_LINES_SOURCE_VENDOR Vendor Source
PO_REQ_DISTRIBUTIONS_ALL_DFV PO_PDF_REQ_PROJECT_ACCOUNTING Requisition Project Information
RCV_TRANSACTIONS1_DFV PO_PDF_RETURN_FROM Return From
RCV_SHIPMENT_LINES1_DFV PO_PDF_SHIP_LINES_DESTINATION Shipment Destination Details
RCV_TRANSACTIONS_INTERFAC1_DFV PO_PDF_TRANSACTION_DESTINATION Transaction Destination
PO_POSITION_CONTROLS_ALL_DFV PO_POSITION_CONTROLS Position Controls
PO_QUOTATION_APPROVALS_ALL_DFV PO_QUOTATION_APPROVALS Quotation Approvals
PO_RELEASES_ALL_DFV PO_RELEASES PO Releases
PO_RELEASES_ARCHIVE_ALL_DFV PO_RELEASES_ARCHIVE Releases Archive
PO_REQEXPRESS_HEADERS_ALL_DFV PO_REQEXPRESS_HEADERS ReqExpress Headers
PO_REQEXPRESS_LINES_ALL1_DFV PO_REQEXPRESS_LINES ReqExpress Lines
PO_REQUISITION_HEADERS_ALL_DFV PO_REQUISITION_HEADERS Requisition Headers
PO_REQUISITION_LINES_ALL3_DFV PO_REQUISITION_LINES Requisition Lines
PO_REQ_DISTRIBUTIONS_ALL1_DFV PO_REQ_DISTRIBUTIONS Requisition Distributions
PO_RFQ_VENDORS_DFV PO_RFQ_VENDORS RFQ Vendors
PO_UN_NUMBERS_B_DFV PO_UN_NUMBERS UN Numbers
PO_REQEXPRESS_HEADERS_ALL1_DFV PO_USSGL_TRANSACTION OGF Transaction Detail
PO_VENDORS_DFV PO_VENDORS Vendors
PO_VENDOR_CONTACTS_DFV PO_VENDOR_CONTACTS Vendor Contacts
PO_VENDOR_LIST_ENTRIES_DFV PO_VENDOR_LIST_ENTRIES Vendor List Entries
PO_VENDOR_LIST_HEADERS_DFV PO_VENDOR_LIST_HEADERS Vendor List Headers
PO_VENDOR_SITES_ALL_DFV PO_VENDOR_SITES Vendor Sites
RCV_LOTS_INTERFACE_DFV RCV_LOTS_INTERFACE Lots Interface
RCV_RECEIVING_SUB_LEDGER_DFV RCV_RECEIVING_SUB_LEDGER Receiving Sub Ledger
RCV_ROUTING_HEADERS_DFV RCV_ROUTING_HEADERS Routing Headers
RCV_ROUTING_STEPS_DFV RCV_ROUTING_STEPS Routing Steps
RCV_SHIPMENT_HEADERS_DFV RCV_SHIPMENT_HEADERS RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES_DFV RCV_SHIPMENT_LINES RCV_SHIPMENT_LINES
RCV_TRANSACTIONS_DFV RCV_TRANSACTIONS Receiving Transactions
RCV_TRANSACTIONS_INTERFACE_DFV RCV_TRANSACTIONS_INTERFACE Receiving Transactions Interface

Views in PO Receiving

List of views in Oracle PO Receiving

RCV_AEL_GL_V
RCV_AEL_SL_MRC_V
RCV_AEL_SL_V
RCV_CONFIRM_RECEIPT_V
RCV_COR_SUP_LOTS_V
RCV_CORRECTIONS_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_INT_REQ_V
RCV_ENTER_RECEIPTS_INTERNAL_V
RCV_ENTER_RECEIPTS_INVENTORY_V
RCV_ENTER_RECEIPTS_LCM_V
RCV_ENTER_RECEIPTS_PO_V
RCV_ENTER_RECEIPTS_RMA_V
RCV_ENTER_RECEIPTS_SUP_INT_V
RCV_ENTER_RECEIPTS_SUPPLIER_V
RCV_ENTER_RECEIPTS_V
RCV_FTE_HEADERS_V
RCV_FTE_LINES_V
RCV_FTE_TRANSACTIONS_V
RCV_GRP_RCV_ERV
RCV_LN_RCV_ERV
RCV_LOTS_INTERFACE_DFV
RCV_MSH_V
RCV_MSL_V
RCV_MUR_V
RCV_PO_ITEMS_V
RCV_REC_ACCT_DISTR_MRC_V
RCV_REC_SUB_LEDGER_MRC_V
RCV_RECEIPT_CONF_LOTSERIAL_V
RCV_RECEIPT_CONFIRMATION_HDR_V
RCV_RECEIPT_CONFIRMATION_LPN_V
RCV_RECEIPT_CONFIRMATION_TXN_V
RCV_RECEIPT_CONFIRMATION_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_SUB_LEDGER_DFV
RCV_RECEIVING_VALUE_VIEW
RCV_RETURNS_V
RCV_ROUTING_HEADERS
RCV_ROUTING_HEADERS_DFV
RCV_ROUTING_STEPS_DFV
RCV_SERIAL_CORRECTION_V
RCV_SHIPMENT_HEADERS_DFV
RCV_SHIPMENT_HEADERS_MRC_V
RCV_SHIPMENT_HEADERS_V
RCV_SHIPMENT_LINES_DFV
RCV_SHIPMENT_LINES1_DFV
RCV_SOURCES_BOTH_VAL_V
RCV_SUB_LEDGER_DET_MRC_V
RCV_SUPPLIERS_VAL_V
RCV_TRANSACTIONS_DFV
RCV_TRANSACTIONS_INTERFAC1_DFV
RCV_TRANSACTIONS_INTERFACE_DFV
RCV_TRANSACTIONS_MRC_V
RCV_TRANSACTIONS_V
RCV_TRANSACTIONS1_DFV
RCV_TRX_INT_LOTS_V
RCV_TRX_INT_SERIALS_V
RCV_UNPROCESSED_LOT_ISSUES_V
RCV_UNPROCESSED_LOTS_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