APPS.XNB_CMN_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 776: FROM oe_order_headers_all ohdr,

772: BEGIN
773:
774: SELECT ohdr.order_number
775: INTO l_order_num
776: FROM oe_order_headers_all ohdr,
777: oe_order_lines_all oline
778: WHERE ohdr.header_id = oline.header_id
779: AND oline.line_id = l_doc_no;
780:

Line 1195: FROM oe_order_headers_all ohdr,

1191: BEGIN
1192:
1193: SELECT ohdr.order_number
1194: INTO l_order_num
1195: FROM oe_order_headers_all ohdr,
1196: oe_order_lines_all oline
1197: WHERE ohdr.header_id = oline.header_id
1198: AND oline.line_id = l_line_id;
1199:

Line 1281: -- SELECT org_id INTO l_org_id FROM oe_order_headers_all

1277: -- Retrieve the Organization Id from the ordernumber
1278: --
1279: --------------------------------------------------------------------------------
1280:
1281: -- SELECT org_id INTO l_org_id FROM oe_order_headers_all
1282: -- WHERE order_number = l_order_no;
1283:
1284: --------------------------------------------------------------------------------
1285: -- Retrieve the organization id from the OM Order Header Attribute

Line 2051: FROM oe_order_headers_all head,

2047: BEGIN
2048:
2049: SELECT count(line.line_id)
2050: INTO l_num
2051: FROM oe_order_headers_all head,
2052: oe_order_lines_all line,
2053: mtl_system_items_vl item
2054: WHERE head.order_number = l_order_number
2055: AND head.header_id = line.header_id

Line 2077: FROM oe_order_headers_all

2073: BEGIN
2074:
2075: SELECT org_id
2076: INTO l_org_id
2077: FROM oe_order_headers_all
2078: WHERE order_number = l_order_number;
2079:
2080: EXCEPTION
2081: