DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on OE_ORDER_LINES_ALL

Line 1848: from oe_order_lines_all

1844: return NUMBER IS
1845:
1846: CURSOR c_order_line_info(c_order_line_id number) is
1847: SELECT source_document_type_id, source_document_id, source_document_line_id
1848: from oe_order_lines_all
1849: where line_id = c_order_line_id;
1850:
1851: l_order_line_info c_order_line_info%ROWTYPE;
1852:

Line 1861: oe_order_lines_all ol

1857: destination_organization_id,
1858: deliver_to_location_id,
1859: pl.requisition_line_id
1860: from po_requisition_lines_all pl,
1861: oe_order_lines_all ol
1862: where ol.source_document_type_id = 10
1863: AND ol.line_id = c_order_line_id
1864: and pl.requisition_line_id = c_po_line_id
1865: and pl.requisition_line_id = ol.source_document_line_id