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 CODE ORACLE FORM NAME
POXACCWO Accrual Write-Offs
POXAPINQ PO View Invoice Summary
POXBWVRP AutoCreate Documents GUI
POXCPDOC PO Copy Document
POXDOCON Control Documents GUI
POXDOFDO Forward Documents
POXDOPRE Enter Preferences GUI
POXPCATN Exceeded Price Tolerances
POXPODMC Define MassCancel
POXPOEAC Enter Acceptances
POXPOEPO Enter Purchase Orders  GUI
POXPOERL Enter Release GUI
POXPORMC Run MassCancel
POXPOVCT Define Notification Control GUI
POXPOVPO Purchase Order Summary GUI
POXQUEMQ Enter Vendor Quotation Lists
POXRQARQ Assign Requisitions
POXRQERQ Enter Requisitions  GUI
POXRQTMP Enter ReqExpress Template GUI
POXRQVRQ Requisition Summary GUI
POXSCASL Define Approved Supplier List
POXSCERQ Enter RFQ’s and Quotes  GUI
POXSCSAQ Quote Annalysis
POXSCSIC Supplier Item Catalog
POXSCVAR Enter Supplier Autosource Rules GUI
POXSTASL Setup Approved Supplier List
POXSTCPP Control Purchasing Periods GUI
POXSTDBY Define Buyers GUI
POXSTDCG Define Control Groups GUI
POXSTDDT Define Document Types GUI
POXSTDHC Define Hazard Classes GUI
POXSTDLC Define Lookup Codes GUI
POXSTDLT Define Line Types GUI
POXSTDPC Define Position Controls GUI
POXSTDPO Define Purchasing Options GUI
POXSTDQC Define Quality Inspection Codes GUI
POXSTDUN Define UN Numbers GUI
POXSTNOT View Notifications GUI
POXSTPCP AutoSubmit GUI
POXSVASL Summary Approved Supplier List
POXTAXCT View Tax Details By Code
POXTAXDT View Tax Details
RCVRCERC Enter Receipts GUI
RCVRCMUR Match Unordered Receipts
RCVRCVRC View Receiving Transactions GUI
RCVSHESH Maintain Shipments
RCVSTDRO Define Receiving Options GUI
RCVTXECO Enter Corrections GUI
RCVTXERE Enter Returns GUI
RCVTXERT Enter Receiving Transactions GUI
RCVTXVTX View Transactions Status GUI
POXRUACC Expense Account Rules
POXGAORG Organization Assignment for Global Agreements
POASTDCM Define Survey
POXSTIFT Define Information Templates
POXSTDCS Define Catalog Server Loader Values
POXSTITS Define Catalog Server Item Sources
POXSTPRS Define Catalog Server for External Suppliers
POXSTRLM Define Catalog Server Realms
POXPRCDF Price Differentials
RCVMSHST View Message History Form GUI
POASTDSR Manage 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