All Modules Interface Tables


                      All modules Interface Tables

GL INTERFACE TABLES

TNAME TABTYPE
 
------------------------------ ------- ----------------------
GL_BUDGET_INTERFACE TABLE
GL_DAILY_RATES_INTERFACE TABLE
GL_IEA_INTERFACE TABLE
GL_INTERFACE TABLE
GL_INTERFACE_CONTROL TABLE
GL_INTERFACE_HISTORY TABLE

AP INTERFACE TABLES

TNAME TABTYPE
 
------------------------------ ------- ------------------------
AP_INTERFACE_CONTROLS TABLE
AP_INTERFACE_REJECTIONS TABLE
AP_INVOICES_INTERFACE TABLE
AP_INVOICE_LINES_INTERFACE TABLE


AR INTERFACE TABLES

TNAME TABTYPE
------------------------------ --------------------------------------
AR_PAYMENTS_INTERFACE_ALL TABLE
AR_TAX_INTERFACE TABLE
HZ_DQM_SYNC_INTERFACE TABLE
HZ_PARTY_INTERFACE TABLE
HZ_PARTY_INTERFACE_ERRORS TABLE
RA_CUSTOMERS_INTERFACE_ALL TABLE
RA_INTERFACE_DISTRIBUTIONS_ALL TABLE
RA_INTERFACE_ERRORS_ALL TABLE
RA_INTERFACE_LINES_ALL TABLE
RA_INTERFACE_SALESCREDITS_ALL TABLE


FA INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- ----------------------
FA_BUDGET_INTERFACE TABLE
FA_INV_INTERFACE TABLE
FA_PRODUCTION_INTERFACE TABLE
FA_TAX_INTERFACE TABLE

INVENTORY INTERFACE TABLES

TNAME TABTYPE
 
------------------------------ ------- ------------------------------------
MTL_CC_ENTRIES_INTERFACE TABLE
MTL_CC_INTERFACE_ERRORS TABLE
MTL_CI_INTERFACE TABLE
MTL_CI_XREFS_INTERFACE TABLE
MTL_COPY_ORG_INTERFACE TABLE
MTL_CROSS_REFERENCES_INTERFACE TABLE
MTL_DEMAND_INTERFACE TABLE
MTL_DESC_ELEM_VAL_INTERFACE TABLE
MTL_EAM_ASSET_NUM_INTERFACE TABLE
MTL_EAM_ATTR_VAL_INTERFACE TABLE
MTL_INTERFACE_ERRORS TABLE

TNAME TABTYPE
 
------------------------------ ------- --------------------------------------
MTL_INTERFACE_PROC_CONTROLS TABLE
MTL_ITEM_CATEGORIES_INTERFACE TABLE
MTL_ITEM_CHILD_INFO_INTERFACE TABLE
MTL_ITEM_REVISIONS_INTERFACE TABLE
MTL_ITEM_SUB_INVS_INTERFACE TABLE
MTL_OBJECT_GENEALOGY_INTERFACE TABLE
MTL_RELATED_ITEMS_INTERFACE TABLE
MTL_RESERVATIONS_INTERFACE TABLE
MTL_RTG_ITEM_REVS_INTERFACE TABLE
MTL_SECONDARY_LOCS_INTERFACE TABLE
MTL_SERIAL_NUMBERS_INTERFACE TABLE

TNAME TABTYPE
 
------------------------------ ------- ------------------------------------
MTL_SO_RMA_INTERFACE TABLE
MTL_SYSTEM_ITEMS_INTERFACE TABLE
MTL_TRANSACTIONS_INTERFACE TABLE
MTL_TRANSACTION_LOTS_INTERFACE TABLE
MTL_TXN_COST_DET_INTERFACE TABLE

PO INTERFACE TABLES

TNAME TABTYPE
 
------------------------------ ------- -------------------------
PO_DISTRIBUTIONS_INTERFACE TABLE
PO_HEADERS_INTERFACE TABLE
PO_INTERFACE_ERRORS TABLE
PO_LINES_INTERFACE TABLE
PO_REQUISITIONS_INTERFACE_ALL TABLE
PO_REQ_DIST_INTERFACE_ALL TABLE
PO_RESCHEDULE_INTERFACE TABLE
RCV_HEADERS_INTERFACE TABLE
RCV_LOTS_INTERFACE TABLE
RCV_SERIALS_INTERFACE TABLE
RCV_TRANSACTIONS_INTERFACE TABLE

BOM INTERFACE TABLES

TNAME TABTYPE
 
------------------------------ ------- ----------------------------------
BOM_BILL_OF_MTLS_INTERFACE TABLE
BOM_INTERFACE_DELETE_GROUPS TABLE
BOM_INVENTORY_COMPS_INTERFACE TABLE
BOM_OP_RESOURCES_INTERFACE TABLE
BOM_OP_ROUTINGS_INTERFACE TABLE
BOM_OP_SEQUENCES_INTERFACE TABLE
BOM_REF_DESGS_INTERFACE TABLE
BOM_SUB_COMPS_INTERFACE TABLE
CST_COMP_SNAP_INTERFACE TABLE
CST_INTERFACE_ERRORS TABLE
CST_ITEM_COSTS_INTERFACE TABLE
CST_ITEM_CST_DTLS_INTERFACE TABLE
CST_PC_COST_DET_INTERFACE TABLE
CST_PC_ITEM_COST_INTERFACE TABLE

WIP INTERFACE TABLES

TNAME TABTYPE
------------------------------ ------- --------------------------
WIP_COST_TXN_INTERFACE TABLE
WIP_INTERFACE_ERRORS TABLE
WIP_JOB_DTLS_INTERFACE TABLE
WIP_JOB_SCHEDULE_INTERFACE TABLE
WIP_MOVE_TXN_INTERFACE TABLE
WIP_SCHEDULING_INTERFACE TABLE
WIP_TXN_INTERFACE_ERRORS TABLE

ORDER MANAGEMENT INTERFACE TABLES

TNAME TABTYPE
 
------------------------------ ------- -----------------------------------
SO_CONFIGURATIONS_INTERFACE TABLE
SO_HEADERS_INTERFACE_ALL TABLE
SO_HEADER_ATTRIBUTES_INTERFACE TABLE
SO_LINES_INTERFACE_ALL TABLE
SO_LINE_ATTRIBUTES_INTERFACE TABLE
SO_LINE_DETAILS_INTERFACE TABLE
SO_PRICE_ADJUSTMENTS_INTERFACE TABLE
SO_SALES_CREDITS_INTERFACE TABLE
SO_SERVICE_DETAILS_INTERFACE TABLE
WSH_DELIVERIES_INTERFACE TABLE
WSH_FREIGHT_CHARGES_INTERFACE TABLE
WSH_PACKED_CONTAINER_INTERFACE TABLE



Type Of Interface
Interface Table
Base Table



                                                                                                       
Inventory



Item Interface
mtl_system_item_interface
mtl_system_items

mtl_item_revisions_interface
mtl_item_revisions

mtl_item_categories_interface
mtl_item_categories
Open Transaction Interace
mtl_transaction_interface
mtl_material_transactions

mtl_transaction_lots_interface
mtl_transaction_lots_numbers

mtl_serial_numbers_interface
mtl_serial_numbers
Receiving Transaction Interface
rcv_headers_interface
rcv_shipment_headers
(for ASN's)
rcv_transactions_interface
rcv_shipment_lines




                                                    Purchasing



Requisition Interface
po_requisitions_interface_all
po_requisition_headers_all
(for Requisitions)

po_requisition_lines_all


po_req_distributions_all
For rescheuling info. From planning system
po_reschedule_interface




Purchase Order Interface
po_headers_interface
po_headers_all

po_lines_interface
po_lines_all

po_distributions_interface
po_distributions_all





rcv_transactions

Order Management



order Import
oe_headers_iface_all
oe_order_headers_all

oe_lines_iface_all
oe_lines_all

oe_lotserials_iface_all
oe_lot_serial_numbers

oe_credits_iface_all
oe_sales_credits

oe_actions_iface_all


oe_price_adjs_iface_all
oe_price_adjustments

oe_reservtns_iface_all



Pricing :


QP_List_Headers





QP_List_lines


Shipping :
ship confirm open interface
WSH_DELIVERIES_INTERFACE
WSH_NEW_DELIVERIES

wsh_packed_container_interface
WSH_DELIVERY_DETAILS

wsh_picking_details_interface
WSH_DELIVERY_ASSIGNMENTS.

wsh_freight_charge_interface
wsh_deliveries


wsh_packed_containers


so_picking_line_details


so_freight_charges


BOM
Open Bills of Material Interface
BOM_BILL_OF_MTLS_INTERFACE
bom_bill_of_materials

BOM_INVENTORY_COMPS_INTERFACE
bom_inventory_components

BOM_REF_DESGS_INTERFACE
bom_reference_designators

BOM_SUB_COMPS_INTERFACE
bom_substitute_components

MTL_ITEM_REVISIONS_INTERFACE
mtl_item_revisions
 Open Routing Interface
BOM_OP_ROUTINGS_INTERFACE
bom_operational_routings

BOM_OP_SEQUENCES_INTERFACE
bom_operation_sequences

BOM_OP_RESOURCES_INTERFACE
bom_operation_resources

MTL_RTG_ITEM_REVS_INTERFACE






WIP



move transaction interface
wip_move_txn_interface
wip_move_transactions
resource transaction interface
wip_cost_txn_interface

work order_interface
wip_job_shedule_interface
wip_discrete_jobs

wip_job_dtls_interface
wip_repetitive_schedules





MPS/MRP



Forecast Intf
mrp_forecast_interface
mrp_forecast_dates,mrp_forecast_items
Master Schedule Intf.
mrp_schedule_interface
mrp_schedule_dates, mrp_schedule_items

No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...