APPS.OE_APPROVALS_WF dependencies on OE_ORDER_HEADERS_ALL

Line 190: from oe_order_headers_all

186: IF itemtype = OE_GLOBALS.G_WFI_NGO THEN
187: IF l_sales_document_type_code = 'O' THEN
188: select sold_to_org_id, expiration_date, salesrep_id
189: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
190: from oe_order_headers_all
191: where header_id = to_number(itemkey);
192: ELSE
193: select obha.sold_to_org_id, obhe.end_date_active, obha.salesrep_id
194: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

Line 424: from oe_order_headers_all

420: ----???? Join to the value table
421: IF l_sales_document_type_code = 'O' THEN
422: select sold_to_org_id, expiration_date, salesrep_id
423: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
424: from oe_order_headers_all
425: where header_id = l_transaction_id;
426: ELSE
427:
428: select obha.sold_to_org_id, obhe.end_date_active, obha.salesrep_id

Line 590: from oe_order_headers_all

586:
587: ELSE
588: select ORDER_TYPE_ID, nvl(TRANSACTION_PHASE_CODE, 'F')
589: into l_transaction_type_id, l_transaction_phase_code
590: from oe_order_headers_all
591: where header_id = p_transaction_id;
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
594: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);

Line 1443: FROM oe_order_headers_all -- 16084377 AME BSA

1439:
1440: IF l_sales_document_type_code = 'O' THEN
1441: SELECT quote_number
1442: INTO l_transaction_number
1443: FROM oe_order_headers_all -- 16084377 AME BSA
1444: WHERE header_id = TO_NUMBER (itemkey);
1445: ELSE
1446: SELECT ORDER_number -- it is order number. Not quote number.
1447: INTO l_transaction_number

Line 1904: FROM oe_order_headers_all

1900: order_type_id
1901: INTO l_sold_to_org_id, l_expiration_date,
1902: l_salesrep_id, l_transaction_phase_code,
1903: l_transaction_type_id
1904: FROM oe_order_headers_all
1905: WHERE header_id = TO_NUMBER (itemkey);
1906: ELSE
1907: SELECT obha.sold_to_org_id, obhe.end_date_active,
1908: obha.salesrep_id,

Line 3350: FROM oe_order_headers_all

3346: SELECT use_ame_approval
3347: INTO l_ame_used
3348: FROM oe_transaction_types_all
3349: WHERE transaction_type_id = (SELECT order_type_id
3350: FROM oe_order_headers_all
3351: WHERE header_id = TO_NUMBER (itemkey));
3352:
3353: END IF ;
3354: EXCEPTION

Line 3665: FROM oe_order_headers_all

3661: AND fl.LANGUAGE = fndl.language_code
3662: AND fndl.installed_flag = 'B'
3663: AND fl.lookup_code = hp.category_code
3664: AND party_id = (SELECT sold_to_org_id
3665: FROM oe_order_headers_all
3666: WHERE header_id = p_header_id);
3667: EXCEPTION
3668: WHEN OTHERS THEN
3669: l_cust_category:= NULL ;