APPS.CSP_PARTS_ORDER dependencies on OE_ORDER_HEADERS_ALL

Line 577: FROM OE_ORDER_HEADERS_ALL

573: -- source operating unit
574: BEGIN
575: SELECT org_id
576: INTO l_source_operating_unit
577: FROM OE_ORDER_HEADERS_ALL
578: WHERE header_id = l_oe_header_id;
579: EXCEPTION
580: WHEN NO_DATA_FOUND THEN
581: RAISE NO_DATA_FOUND;

Line 4779: select org_id into l_org_id from oe_order_headers_all where header_id = p_oe_header_id;

4775: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,
4776: 'p_oe_header_id = ' || p_oe_header_id);
4777: end if;
4778:
4779: select org_id into l_org_id from oe_order_headers_all where header_id = p_oe_header_id;
4780: l_org_org_id := mo_global.get_current_org_id;
4781:
4782: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4783: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 5118: oe_order_headers_all oeh

5114: SELECT oeh.order_number
5115: FROM csp_requirement_lines cl,
5116: csp_req_line_details cld,
5117: oe_order_lines_all oel,
5118: oe_order_headers_all oeh
5119: WHERE cl.requirement_header_id = p_req_header_id
5120: AND cl.requirement_line_id = cld.requirement_line_id
5121: AND cld.source_type = 'IO'
5122: AND cld.source_id = oel.line_id