APPS.OE_INV_IFACE_CONC dependencies on OE_ORDER_LINES_ALL

Line 74: FROM oe_order_headers H, oe_order_lines_all L

70: l_file_val VARCHAR2(80);
71:
72: CURSOR line_cur IS
73: SELECT H.org_id, H.header_id, L.line_id
74: FROM oe_order_headers H, oe_order_lines_all L
75: WHERE
76: H.org_id = NVL(p_org_id, H.org_id)
77: AND H.header_id = L.header_id
78: AND H.order_number >= NVL(p_order_number_low, H.order_number)

Line 94: FROM oe_order_lines_all

90:
91: /*
92: CURSOR line_cur(p_header_id IN NUMBER) IS
93: SELECT line_id, org_id
94: FROM oe_order_lines_all
95: WHERE header_id = p_header_id
96: AND inventory_item_id = NVL(p_item, inventory_item_id)
97: AND NVL(ship_from_org_id, -1) = NVL(p_ship_from_org_id, NVL(ship_from_org_id, -1))
98: AND open_flag = 'Y';