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 423: from oe_order_headers_all

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

Line 588: from oe_order_headers_all

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