PO Interface Tables November 13, 2007
Posted by Muhammad Habib in Oracle Applications, Oracle Purchasing.13 comments
If some customized system have the data and we want to Generate the interface of PO and to generate the PO directly in Oracle Purchasing; means we enter the data in our system and want a interface that directly generate the entry in PO tables, two interface tables are involved PO_HEADERS_INTERFACE and PO_LINES_INTERFACE:
INSERT INTO po.po_headers_interface
(interface_header_id, batch_id, process_code,
note_to_vendor, action, document_type_code,
currency_code, payment_terms,closed_code,
created_by, rate_type, rate_date, rate,
agent_name, agent_id, vendor_id, vendor_site_id,
ship_to_location_id, bill_to_location_id)
———-
INSERT INTO po.po_lines_interface
(interface_line_id,
interface_header_id, line_num,
line_type, item_id, item_description,
unit_of_measure, quantity,
unit_price, promised_date,
ship_to_organization_id,
ship_to_location_id,
closed_code,
created_by,
list_price_per_unit)
———–
Habib's Oracle World 