APPS.OE_APPROVALS_WF dependencies on OE_BLANKET_HEADERS_ALL

Line 195: from oe_blanket_headers_all obha, oe_blanket_headers_ext obhe

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
195: from oe_blanket_headers_all obha, oe_blanket_headers_ext obhe
196: where obha.header_id = to_number(itemkey)
197: and obha.order_number = obhe.order_number;
198: END IF;
199:

Line 430: from oe_blanket_headers_all obha,

426: ELSE
427:
428: select obha.sold_to_org_id, obhe.end_date_active, obha.salesrep_id
429: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
430: from oe_blanket_headers_all obha,
431: oe_blanket_headers_ext obhe
432: where obha.header_id = l_transaction_id
433: and obha.order_number = obhe.order_number;
434:

Line 580: from oe_blanket_headers_all

576: -- If p_sales_document_type_code is not B, it is either a quote or order or line
577: IF nvl(p_sales_document_type_code, 'XXXX') = 'B' THEN
578: select ORDER_TYPE_ID, nvl(TRANSACTION_PHASE_CODE, 'F')
579: into l_transaction_type_id, l_transaction_phase_code
580: from oe_blanket_headers_all
581: where header_id = p_transaction_id;
582: IF l_debug_level > 0 THEN
583: oe_debug_pub.add('Transaction_type_id->' || l_transaction_type_id, 1) ;
584: oe_debug_pub.add('TransactionPhase->' || l_transaction_phase_code, 1);

Line 1448: FROM oe_blanket_headers_all

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
1448: FROM oe_blanket_headers_all
1449: WHERE header_id = TO_NUMBER (itemkey);
1450: END IF ;
1451:
1452: END IF;

Line 1915: FROM oe_blanket_headers_all obha,

1911: INTO l_sold_to_org_id, l_expiration_date,
1912: l_salesrep_id,
1913: l_transaction_phase_code,
1914: l_transaction_type_id
1915: FROM oe_blanket_headers_all obha,
1916: oe_blanket_headers_ext obhe
1917: WHERE obha.header_id = TO_NUMBER (itemkey)
1918: AND obha.order_number = obhe.order_number;
1919: END IF;

Line 3341: FROM oe_blanket_headers_all -- 16084377 AME BSA

3337: SELECT use_ame_approval
3338: INTO l_ame_used
3339: FROM oe_transaction_types_all
3340: WHERE transaction_type_id = (SELECT order_type_id
3341: FROM oe_blanket_headers_all -- 16084377 AME BSA
3342: WHERE header_id = TO_NUMBER (itemkey));
3343:
3344: ELSE
3345:

Line 3647: FROM oe_blanket_headers_all

3643: AND fl.LANGUAGE = fndl.language_code
3644: AND fndl.installed_flag = 'B'
3645: AND fl.lookup_code = hp.category_code
3646: AND party_id = (SELECT sold_to_org_id
3647: FROM oe_blanket_headers_all
3648: WHERE header_id = p_header_id);
3649: EXCEPTION
3650: WHEN OTHERS THEN
3651: l_cust_category:= NULL ;