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 720: FROM oe_order_headers_all oh, oe_transaction_types_tl t

716: document := substrb(l_header_txt, 1, 240);
717: ELSIF l_sales_document_type_code = 'O' THEN
718: SELECT oh.order_number, oh.order_type_id, t.name
719: INTO l_quote_number, l_transaction_type_id, l_transaction_type_name
720: FROM oe_order_headers_all oh, oe_transaction_types_tl t
721: WHERE header_id = l_header_id
722: AND t.language = userenv('LANG')
723: AND t.transaction_type_id = oh.order_type_id;
724:

Line 884: from oe_order_headers_all

880:
881: IF l_wf_item_count = 0 THEN --we are in fulfillment phase and it has no nego phase
882: select count(1)
883: into l_so_count
884: from oe_order_headers_all
885: where header_id = p_header_id;
886:
887: IF l_so_count > 0 THEN
888: l_sales_document_type_code := 'O';

Line 1181: from oe_order_headers_all

1177: -- should be a sales order, as BSA UI won't call this API in fulfillment phase, but
1178: -- double check to confirm
1179: select count(1)
1180: into l_so_count
1181: from oe_order_headers_all
1182: where header_id = p_header_id;
1183:
1184: IF l_so_count > 0 THEN
1185: l_sales_document_type_code := 'O';

Line 1298: from oe_order_headers_all

1294: IF l_sales_document_type_code = 'O' THEN
1295:
1296: select sold_to_org_id, expiration_date, salesrep_id
1297: into l_sold_to_org_id, l_expiration_date, l_salesrep_id
1298: from oe_order_headers_all
1299: where header_id = p_header_id;
1300: ELSE
1301: select sold_to_org_id, expiration_date, salesrep_id
1302: into l_sold_to_org_id, l_expiration_date, l_salesrep_id

Line 1401: from oe_order_headers_all

1397: l_sales_document_type_code := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'SALES_DOCUMENT_TYPE_CODE');
1398: IF l_sales_document_type_code = 'O' THEN
1399: select expiration_date
1400: into l_expiration_date
1401: from oe_order_headers_all
1402: where header_id = to_number(itemkey);
1403: ELSE
1404: -- even though there is no offer expiration date for blanket for now
1405: -- we will still fetch it for the future