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