APPS.OE_HOLDS_PUB dependencies on OE_ORDER_HEADERS

Line 446: FROM OE_ORDER_HEADERS

442: END IF;
443:
444: SELECT 'Valid Entity'
445: INTO l_dummy
446: FROM OE_ORDER_HEADERS
447: WHERE HEADER_ID = p_header_id
448: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
449:
450:

Line 455: FROM OE_ORDER_HEADERS

451: ELSIF p_hold_entity_code = 'C' THEN
452:
453: SELECT 'Valid Entity'
454: INTO l_dummy
455: FROM OE_ORDER_HEADERS
456: WHERE HEADER_ID = p_header_id
457: AND SOLD_TO_ORG_ID = p_hold_entity_id
458: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
459:

Line 464: FROM OE_ORDER_HEADERS

460: ELSIF p_hold_entity_code = 'S' THEN
461: -- XXX Confirm this code
462: SELECT 'Valid Entity'
463: INTO l_dummy
464: FROM OE_ORDER_HEADERS
465: WHERE HEADER_ID = p_header_id
466: AND SHIP_TO_ORG_ID = p_hold_entity_id
467: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
468: ELSE

Line 483: FROM OE_ORDER_HEADERS

479: END IF;
480:
481: SELECT 'Valid Entity'
482: INTO l_dummy
483: FROM OE_ORDER_HEADERS
484: WHERE HEADER_ID = p_hold_entity_id2
485: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
486:
487:

Line 492: FROM OE_ORDER_HEADERS

488: ELSIF p_hold_entity_code2 = 'C' THEN
489:
490: SELECT 'Valid Entity'
491: INTO l_dummy
492: FROM OE_ORDER_HEADERS
493: WHERE HEADER_ID = p_header_id
494: AND SOLD_TO_ORG_ID = p_hold_entity_id2
495: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
496:

Line 501: FROM OE_ORDER_HEADERS

497: ELSIF p_hold_entity_code2 = 'S' THEN
498: -- XXX Confirm this code
499: SELECT 'Valid Entity'
500: INTO l_dummy
501: FROM OE_ORDER_HEADERS
502: WHERE HEADER_ID = p_header_id
503: AND SHIP_TO_ORG_ID = p_hold_entity_id2
504: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
505: ELSE

Line 1805: FROM oe_order_headers_all

1801: IF l_org_id IS NULL THEN
1802: BEGIN
1803: SELECT org_id
1804: INTO l_org_id
1805: FROM oe_order_headers_all
1806: WHERE header_id=p_hdr_id;
1807: EXCEPTION
1808: WHEN NO_DATA_FOUND THEN
1809: x_result_out := FND_API.G_FALSE;

Line 2973: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;

2969: --
2970: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2971: --
2972: --ER#7479609 start
2973: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
2974: l_line_rec OE_ORDER_LINES_ALL%rowtype;
2975: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
2976: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
2977:

Line 3010: FROM oe_order_headers

3006: l_header_id := p_entity_id;
3007: --ER#7479609 start
3008: BEGIN
3009: SELECT * INTO l_header_rec
3010: FROM oe_order_headers
3011: WHERE header_id=l_header_id;
3012:
3013:
3014: EXCEPTION

Line 3035: FROM oe_order_headers OH,oe_order_lines OL

3031: END IF;
3032: --ER#7479609 start
3033: BEGIN
3034: SELECT OH.* INTO l_header_rec
3035: FROM oe_order_headers OH,oe_order_lines OL
3036: WHERE OH.header_id=OL.header_id
3037: AND OL.line_id=l_line_id;
3038:
3039: l_header_id := l_header_rec.header_id;

Line 3328: FROM OE_ORDER_HEADERS_ALL

3324: WHERE header_id=l_header_rec.header_id
3325: AND line_id IS NULL
3326: UNION
3327: SELECT payment_type_code payment_type
3328: FROM OE_ORDER_HEADERS_ALL
3329: WHERE header_id=l_header_rec.header_id) V;
3330:
3331: EXCEPTION
3332: WHEN OTHERS THEN

Line 4266: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;

4262: AND HS.HOLD_ENTITY_ID2 = p_hold_entity_id2
4263: AND HS.HOLD_ENTITY_CODE <> 'O';
4264: */
4265: --ER#7479609 start
4266: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4267: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4268: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4269: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4270:

Line 4301: FROM oe_order_headers

4297:
4298: --ER#7479609 start
4299: BEGIN
4300: SELECT * INTO l_header_rec
4301: FROM oe_order_headers
4302: WHERE header_id=l_header_id;
4303:
4304: EXCEPTION
4305: WHEN OTHERS THEN

Line 4326: FROM oe_order_headers OH,oe_order_lines OL

4322:
4323: --ER#7479609 start
4324: BEGIN
4325: SELECT OH.* INTO l_header_rec
4326: FROM oe_order_headers OH,oe_order_lines OL
4327: WHERE OH.header_id=OL.header_id
4328: AND OL.line_id=l_line_id;
4329:
4330: EXCEPTION

Line 4399: FROM OE_ORDER_HEADERS_ALL

4395: WHERE header_id=l_header_rec.header_id
4396: AND line_id IS NULL
4397: UNION
4398: SELECT payment_type_code payment_type
4399: FROM OE_ORDER_HEADERS_ALL
4400: WHERE header_id=l_header_rec.header_id) V;
4401: EXCEPTION
4402: WHEN OTHERS THEN
4403: null;

Line 5069: FROM OE_ORDER_HEADERS_ALL hdr

5065: AND nvl(src.released_flag, 'N') = 'N')
5066: UNION
5067:
5068: SELECT DISTINCT org_id
5069: FROM OE_ORDER_HEADERS_ALL hdr
5070: WHERE sold_to_org_id = p_hold_entity_id
5071: AND NOT EXISTS (select 1
5072: from oe_hold_sources_all
5073: where hold_entity_id = p_hold_entity_id