APPS.OE_NEGOTIATE_WF dependencies on OE_ORDER_HEADERS_ALL

Line 475: from oe_order_headers_all

471: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');
472: IF l_sales_document_type_code = 'O' THEN
473: select expiration_date
474: into l_expiration_date
475: from oe_order_headers_all
476: where header_id = to_number(itemkey);
477: ELSE
478: -- even though there is no offer expiration date for blanket for now
479: -- we will still fetch it for the future

Line 628: from oe_order_headers_all

624: IF l_sales_document_type_code = 'O' THEN
625: -- ***DATE_CALCULATION***
626: select sold_to_org_id, expiration_date, salesrep_id
627: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
628: from oe_order_headers_all
629: where header_id = to_number(itemkey);
630: ELSE
631: select sold_to_org_id, expiration_date, salesrep_id
632: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

Line 779: FROM oe_order_headers_all oh, oe_transaction_types_tl t

775: SELECT oh.order_number, oh.order_type_id,
776: t.NAME
777: INTO l_quote_number, l_transaction_type_id,
778: l_transaction_type_name
779: FROM oe_order_headers_all oh, oe_transaction_types_tl t
780: WHERE header_id = l_header_id
781: AND t.LANGUAGE = USERENV ('LANG')
782: AND t.transaction_type_id = oh.order_type_id;
783:

Line 939: from oe_order_headers_all

935:
936: IF l_wf_item_count = 0 THEN --we are in fulfillment phase and it has no nego phase
937: select count(1)
938: into l_so_count
939: from oe_order_headers_all
940: where header_id = p_header_id;
941:
942: IF l_so_count > 0 THEN
943: l_sales_document_type_code := 'O';

Line 1236: from oe_order_headers_all

1232: -- should be a sales order, as BSA UI won't call this API in fulfillment phase, but
1233: -- double check to confirm
1234: select count(1)
1235: into l_so_count
1236: from oe_order_headers_all
1237: where header_id = p_header_id;
1238:
1239: IF l_so_count > 0 THEN
1240: l_sales_document_type_code := 'O';

Line 1353: from oe_order_headers_all

1349: IF l_sales_document_type_code = 'O' THEN
1350:
1351: select sold_to_org_id, expiration_date, salesrep_id
1352: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
1353: from oe_order_headers_all
1354: where header_id = p_header_id;
1355: ELSE
1356: select sold_to_org_id, expiration_date, salesrep_id
1357: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

Line 1458: from oe_order_headers_all

1454: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');
1455: IF l_sales_document_type_code = 'O' THEN
1456: select expiration_date
1457: into l_expiration_date
1458: from oe_order_headers_all
1459: where header_id = to_number(itemkey);
1460: ELSE
1461: -- even though there is no offer expiration date for blanket for now
1462: -- we will still fetch it for the future