DBA Data[Home] [Help]

APPS.OE_STANDARD_WF dependencies on OE_ORDER_HEADERS_ALL

Line 214: FROM oe_order_headers_all

210: IF G_RESET_APPS_CONTEXT THEN
211:
212: SELECT org_id
213: INTO l_org_id
214: FROM oe_order_headers_all
215: WHERE header_id = to_number (p_itemkey);
216: IF l_debug_level > 0 THEN
217: oe_debug_pub.add('ORG ID IS ' || l_org_id ) ;
218: END IF;

Line 247: FROM oe_order_headers_all

243: OE_GLOBALS.G_FLOW_RESTARTED := TRUE;
244:
245: SELECT org_id
246: INTO l_org_id
247: FROM oe_order_headers_all
248: WHERE header_id = to_number (p_itemkey);
249:
250: IF NVL(MO_GLOBAL.get_current_org_id, -99) <> l_org_id
251: THEN

Line 476: FROM oe_order_headers_all

472:
473: IF l_sales_document_type_code = 'O' THEN
474: SELECT org_id
475: INTO l_org_id
476: FROM oe_order_headers_all
477: WHERE header_id = to_number (p_itemkey);
478: ELSIF l_sales_document_type_code = 'B' THEN
479: SELECT org_id
480: INTO l_org_id

Line 520: FROM oe_order_headers_all

516:
517: IF l_sales_document_type_code = 'O' THEN
518: SELECT org_id
519: INTO l_org_id
520: FROM oe_order_headers_all
521: WHERE header_id = to_number (p_itemkey);
522: ELSIF l_sales_document_type_code = 'B' THEN
523: SELECT org_id
524: INTO l_org_id

Line 940: FROM oe_order_headers_all

936: IF l_sales_document_type_code = 'O'
937: THEN
938: SELECT org_id
939: INTO l_org_id
940: FROM oe_order_headers_all
941: WHERE header_id = l_header_id;
942: ELSIF l_sales_document_type_code = 'B'
943: THEN
944: SELECT org_id

Line 973: FROM oe_order_headers_all

969: IF g_reset_apps_context
970: THEN
971: SELECT org_id
972: INTO l_org_id
973: FROM oe_order_headers_all
974: WHERE header_id = l_header_id;
975:
976: IF l_debug_level > 0
977: THEN

Line 1012: FROM oe_order_headers_all

1008: IF l_sales_document_type_code = 'O'
1009: THEN
1010: SELECT org_id
1011: INTO l_org_id
1012: FROM oe_order_headers_all
1013: WHERE header_id = l_header_id;
1014: ELSIF l_sales_document_type_code = 'B'
1015: THEN
1016: SELECT org_id

Line 1067: FROM oe_order_headers_all

1063: oe_globals.g_flow_restarted := TRUE;
1064:
1065: SELECT org_id
1066: INTO l_org_id
1067: FROM oe_order_headers_all
1068: WHERE header_id = l_header_id;
1069:
1070: IF l_debug_level > 0
1071: THEN