DBA Data[Home] [Help]

APPS.OE_APPROVALS_WF dependencies on OE_BLANKET_HEADERS_EXT

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 431: oe_blanket_headers_ext obhe

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:
435: END IF;

Line 1916: oe_blanket_headers_ext obhe

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;
1920: