APPS.OE_DROP_SHIP_GRP dependencies on OE_ORDER_LINES_ALL

Line 669: FROM oe_order_lines_all ol,

665: END IF;
666:
667: SELECT ol.line_id
668: INTO l_line_id
669: FROM oe_order_lines_all ol,
670: oe_drop_ship_sources od,
671: rcv_transactions rt
672: WHERE ol.line_id = od.line_id
673: AND ol.source_type_code = 'EXTERNAL'

Line 751: oe_order_lines_all oel

747: INTO x_line_id,
748: x_header_id,
749: x_org_id
750: FROM oe_drop_ship_sources ds,
751: oe_order_lines_all oel
752: WHERE line_location_id = p_po_line_location_id
753: AND oel.line_id = ds.line_id
754: AND oel.header_id = ds.header_id
755: AND nvl(oel.open_flag,'Y') = 'Y'

Line 786: oe_order_lines_all oel

782: INTO x_line_id,
783: x_header_id,
784: x_org_id
785: FROM oe_drop_ship_sources ds,
786: oe_order_lines_all oel
787: WHERE line_location_id = p_po_line_location_id
788: AND oel.line_id = ds.line_id
789: AND oel.header_id = ds.header_id;
790:

Line 809: oe_order_lines_all oel

805: oel.org_id
806: INTO x_header_id,
807: x_org_id
808: FROM oe_drop_ship_sources ds,
809: oe_order_lines_all oel
810: WHERE line_location_id = p_po_line_location_id
811: AND oel.line_id = ds.line_id
812: AND oel.header_id = ds.header_id
813: AND rownum = 1;

Line 833: FROM oe_order_lines_all OL,

829: END IF;
830:
831: SELECT MAX(OL.line_id)
832: INTO x_line_id
833: FROM oe_order_lines_all OL,
834: oe_drop_ship_sources OD,
835: rcv_transactions RT
836: WHERE OL.line_id = OD.line_id
837: AND OL.source_type_code = 'EXTERNAL'

Line 852: oe_order_lines_all oel

848:
849: SELECT count(*)
850: INTO x_num_lines
851: FROM oe_drop_ship_sources ds,
852: oe_order_lines_all oel
853: WHERE line_location_id = p_po_line_location_id
854: AND oel.line_id = ds.line_id
855: AND oel.header_id = ds.header_id;
856:

Line 1223: FROM oe_order_lines_all oel, --oe_order_lines oel, -- Changes for BUG#6032405

1219: x_order_line_info_rec.sales_order_line_ordered_qty2, -- INVCONV
1220: x_order_line_info_rec.sales_order_line_shipped_qty2, -- INVCONV
1221:
1222: x_order_line_info_rec.sales_order_line_status
1223: FROM oe_order_lines_all oel, --oe_order_lines oel, -- Changes for BUG#6032405
1224: oe_lookups oelup
1225: WHERE line_id = l_line_id
1226: AND oelup.lookup_code = oel.flow_status_code
1227: AND oelup.lookup_type = 'LINE_FLOW_STATUS';

Line 1624: oe_order_lines_all l

1620: THEN
1621: SELECT count(*)
1622: INTO l_count
1623: FROM oe_drop_ship_sources ds,
1624: oe_order_lines_all l
1625: WHERE requisition_header_id = p_entity_id_tbl(I)
1626: AND l.line_id = ds.line_id
1627: AND l.header_id = ds.header_id
1628: AND nvl(l.open_flag,'Y') = 'Y'

Line 1634: oe_order_lines_all l

1630: ELSE
1631: SELECT count(*)
1632: INTO l_count
1633: FROM oe_drop_ship_sources ds,
1634: oe_order_lines_all l
1635: WHERE po_header_id = p_entity_id_tbl(I)
1636: AND l.line_id = ds.line_id
1637: AND l.header_id = ds.header_id
1638: AND nvl(l.open_flag,'Y') = 'Y'