APPS.XNB_SALES_ORDER_PVT dependencies on OE_ORDER_LINES_ALL

Line 60: WHERE organization_id = l_so_org_id and inventory_item_id = (select inventory_item_id from oe_order_lines_all where line_id = l_so_line_id);

56:
57: SELECT invoiceable_item_flag
58: INTO l_flag
59: FROM mtl_system_items_b
60: WHERE organization_id = l_so_org_id and inventory_item_id = (select inventory_item_id from oe_order_lines_all where line_id = l_so_line_id);
61:
62: EXCEPTION
63:
64: WHEN NO_DATA_FOUND THEN

Line 165: FROM oe_order_lines_all

161: BEGIN
162:
163: SELECT sold_to_org_id
164: INTO l_cust_acct_id
165: FROM oe_order_lines_all
166: WHERE line_id = l_so_doc_id;
167:
168: EXCEPTION
169:

Line 455: FROM oe_order_lines_all

451: SELECT invoice_to_org_id,
452: sold_to_org_id
453: INTO l_inv_to_org_id,
454: l_sold_to_org_id
455: FROM oe_order_lines_all
456: WHERE line_id = l_doc_id; --DOCUMENT_ID
457:
458: EXCEPTION
459:

Line 1201: oe_order_lines_all line,

1197: CURSOR l_line_ids (p_order_num NUMBER)
1198: IS
1199: SELECT line.line_id
1200: FROM oe_order_headers_all head,
1201: oe_order_lines_all line,
1202: mtl_system_items_vl item
1203: WHERE head.order_number = p_order_num
1204: AND head.header_id = line.header_id
1205: AND line.inventory_item_id = item.inventory_item_id

Line 1260: FROM oe_order_lines_all

1256: SELECT invoice_to_org_id,
1257: sold_to_org_id
1258: INTO l_inv_to_org_id,
1259: l_sold_to_org_id
1260: FROM oe_order_lines_all
1261: WHERE line_id = l_line_id; --DOCUMENT_ID
1262:
1263: EXCEPTION
1264:

Line 1547: oe_order_lines_all line

1543: CURSOR l_line_ids (p_order_num NUMBER)
1544: IS
1545: SELECT line_id
1546: FROM oe_order_headers_all head,
1547: oe_order_lines_all line
1548: WHERE head.header_id = line.header_id
1549: AND head.order_number = p_order_num;
1550:
1551: l_order_number NUMBER;