GL,INV,AP,FA,INV,PO,BOM,WIP, 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 TAB

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




2 Comments

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle AME , kindly contact us http://www.maxmunus.com/contactMaxMunus Offer World Class Virtual Instructor led training on Oracle AME . We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/

Reply


Thanks for the given information you are providing content very usefull to users.
Learn Complete GL Interface Program in Oracle Apps R12 Actual cost of this course is 3,200/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


Hurry-Up Enroll Now and get Free Access to the Entire Course

Reply

Post a Comment