DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on OE_ORDER_LINES_ALL

Line 1829: from oe_order_lines_all

1825: return NUMBER IS
1826:
1827: CURSOR c_order_line_info(c_order_line_id number) is
1828: SELECT source_document_type_id, source_document_id, source_document_line_id
1829: from oe_order_lines_all
1830: where line_id = c_order_line_id;
1831:
1832: l_order_line_info c_order_line_info%ROWTYPE;
1833:

Line 1842: oe_order_lines_all ol

1838: destination_organization_id,
1839: deliver_to_location_id,
1840: pl.requisition_line_id
1841: from po_requisition_lines_all pl,
1842: oe_order_lines_all ol
1843: where ol.source_document_type_id = 10
1844: AND ol.line_id = c_order_line_id
1845: and pl.requisition_line_id = c_po_line_id
1846: and pl.requisition_line_id = ol.source_document_line_id