You are browsing the archive for Technical Design.

Oracle Purchasing Tables

  • 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_GT
  • 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_GT
  • 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

Oracle Purchasing Forms

Oracle Purchasing Forms:

FORM SHORT CODEORACLE FORM NAME
POXACCWOAccrual Write-Offs
POXAPINQPO View Invoice Summary
POXBWVRPAutoCreate Documents GUI
POXCPDOCPO Copy Document
POXDOCONControl Documents GUI
POXDOFDOForward Documents
POXDOPREEnter Preferences GUI
POXPCATNExceeded Price Tolerances
POXPODMCDefine MassCancel
POXPOEACEnter Acceptances
POXPOEPOEnter Purchase Orders  GUI
POXPOERLEnter Release GUI
POXPORMCRun MassCancel
POXPOVCTDefine Notification Control GUI
POXPOVPOPurchase Order Summary GUI
POXQUEMQEnter Vendor Quotation Lists
POXRQARQAssign Requisitions
POXRQERQEnter Requisitions  GUI
POXRQTMPEnter ReqExpress Template GUI
POXRQVRQRequisition Summary GUI
POXSCASLDefine Approved Supplier List
POXSCERQEnter RFQ’s and Quotes  GUI
POXSCSAQQuote Annalysis
POXSCSICSupplier Item Catalog
POXSCVAREnter Supplier Autosource Rules GUI
POXSTASLSetup Approved Supplier List
POXSTCPPControl Purchasing Periods GUI
POXSTDBYDefine Buyers GUI
POXSTDCGDefine Control Groups GUI
POXSTDDTDefine Document Types GUI
POXSTDHCDefine Hazard Classes GUI
POXSTDLCDefine Lookup Codes GUI
POXSTDLTDefine Line Types GUI
POXSTDPCDefine Position Controls GUI
POXSTDPODefine Purchasing Options GUI
POXSTDQCDefine Quality Inspection Codes GUI
POXSTDUNDefine UN Numbers GUI
POXSTNOTView Notifications GUI
POXSTPCPAutoSubmit GUI
POXSVASLSummary Approved Supplier List
POXTAXCTView Tax Details By Code
POXTAXDTView Tax Details
RCVRCERCEnter Receipts GUI
RCVRCMURMatch Unordered Receipts
RCVRCVRCView Receiving Transactions GUI
RCVSHESHMaintain Shipments
RCVSTDRODefine Receiving Options GUI
RCVTXECOEnter Corrections GUI
RCVTXEREEnter Returns GUI
RCVTXERTEnter Receiving Transactions GUI
RCVTXVTXView Transactions Status GUI
POXRUACCExpense Account Rules
POXGAORGOrganization Assignment for Global Agreements
POASTDCMDefine Survey
POXSTIFTDefine Information Templates
POXSTDCSDefine Catalog Server Loader Values
POXSTITSDefine Catalog Server Item Sources
POXSTPRSDefine Catalog Server for External Suppliers
POXSTRLMDefine Catalog Server Realms
POXPRCDFPrice Differentials
RCVMSHSTView Message History Form GUI
POASTDSRManage Survey

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