DBA Data[Home] [Help]

APPS.OE_INV_IFACE_CONC dependencies on OE_ORDER_LINES_ALL

Line 77: FROM oe_order_headers H, oe_order_lines_all L

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

Line 101: FROM oe_order_lines_all

97:
98: /*
99: CURSOR line_cur(p_header_id IN NUMBER) IS
100: SELECT line_id, org_id
101: FROM oe_order_lines_all
102: WHERE header_id = p_header_id
103: AND inventory_item_id = NVL(p_item, inventory_item_id)
104: AND NVL(ship_from_org_id, -1) = NVL(p_ship_from_org_id, NVL(ship_from_org_id, -1))
105: AND open_flag = 'Y';