APPS.OE_HOLDS_PUB dependencies on OE_ORDER_HEADERS

Line 514: FROM OE_ORDER_HEADERS

510: END IF;
511:
512: SELECT 'Valid Entity'
513: INTO l_dummy
514: FROM OE_ORDER_HEADERS
515: WHERE HEADER_ID = p_header_id
516: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
517:
518:

Line 524: FROM OE_ORDER_HEADERS

520: ELSIF p_hold_entity_code IN ('C','CN') THEN -- ER# 11824468
521:
522: SELECT 'Valid Entity'
523: INTO l_dummy
524: FROM OE_ORDER_HEADERS
525: WHERE HEADER_ID = p_header_id
526: AND SOLD_TO_ORG_ID = p_hold_entity_id
527: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
528:

Line 533: FROM OE_ORDER_HEADERS

529: ELSIF p_hold_entity_code = 'S' THEN
530: -- XXX Confirm this code
531: SELECT 'Valid Entity'
532: INTO l_dummy
533: FROM OE_ORDER_HEADERS
534: WHERE HEADER_ID = p_header_id
535: AND SHIP_TO_ORG_ID = p_hold_entity_id
536: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
537: ELSE

Line 552: FROM OE_ORDER_HEADERS

548: END IF;
549:
550: SELECT 'Valid Entity'
551: INTO l_dummy
552: FROM OE_ORDER_HEADERS
553: WHERE HEADER_ID = p_hold_entity_id2
554: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
555:
556:

Line 562: FROM OE_ORDER_HEADERS

558: ELSIF p_hold_entity_code2 IN('C','CN') THEN -- ER# 11824468
559:
560: SELECT 'Valid Entity'
561: INTO l_dummy
562: FROM OE_ORDER_HEADERS
563: WHERE HEADER_ID = p_header_id
564: AND SOLD_TO_ORG_ID = p_hold_entity_id2
565: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
566:

Line 571: FROM OE_ORDER_HEADERS

567: ELSIF p_hold_entity_code2 = 'S' THEN
568: -- XXX Confirm this code
569: SELECT 'Valid Entity'
570: INTO l_dummy
571: FROM OE_ORDER_HEADERS
572: WHERE HEADER_ID = p_header_id
573: AND SHIP_TO_ORG_ID = p_hold_entity_id2
574: AND nvl(TRANSACTION_PHASE_CODE,'F') = 'F';
575: ELSE

Line 1894: FROM oe_order_headers_all

1890: IF l_org_id IS NULL THEN
1891: BEGIN
1892: SELECT org_id
1893: INTO l_org_id
1894: FROM oe_order_headers_all
1895: WHERE header_id=p_hdr_id;
1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN
1898: x_result_out := FND_API.G_FALSE;

Line 3079: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;

3075: --
3076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3077: --
3078: --ER#7479609 start
3079: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
3080: l_line_rec OE_ORDER_LINES_ALL%rowtype;
3081: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
3082: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
3083:

Line 3134: FROM oe_order_headers

3130: l_header_id := p_entity_id;
3131: --ER#7479609 start
3132: BEGIN
3133: SELECT * INTO l_header_rec
3134: FROM oe_order_headers
3135: WHERE header_id=l_header_id;
3136:
3137:
3138: EXCEPTION

Line 3159: FROM oe_order_headers OH,oe_order_lines OL

3155: END IF;
3156: --ER#7479609 start
3157: BEGIN
3158: SELECT OH.* INTO l_header_rec
3159: FROM oe_order_headers OH,oe_order_lines OL
3160: WHERE OH.header_id=OL.header_id
3161: AND OL.line_id=l_line_id;
3162:
3163: l_header_id := l_header_rec.header_id;

Line 3465: FROM OE_ORDER_HEADERS_ALL

3461: WHERE header_id=l_header_rec.header_id
3462: AND line_id IS NULL
3463: UNION
3464: SELECT payment_type_code payment_type
3465: FROM OE_ORDER_HEADERS_ALL
3466: WHERE header_id=l_header_rec.header_id) V;
3467:
3468: EXCEPTION
3469: WHEN OTHERS THEN

Line 4563: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;

4559: AND HS.HOLD_ENTITY_ID2 = p_hold_entity_id2
4560: AND HS.HOLD_ENTITY_CODE <> 'O';
4561: */
4562: --ER#7479609 start
4563: l_header_rec OE_ORDER_HEADERS_ALL%rowtype;
4564: l_line_rec OE_ORDER_LINES_ALL%rowtype;
4565: TYPE entity_rec IS RECORD (entity_code oe_hold_sources_all.hold_entity_code%TYPE,
4566: entity_id oe_hold_sources_all.hold_entity_id%TYPE);
4567:

Line 4604: FROM oe_order_headers

4600:
4601: --ER#7479609 start
4602: BEGIN
4603: SELECT * INTO l_header_rec
4604: FROM oe_order_headers
4605: WHERE header_id=l_header_id;
4606:
4607: EXCEPTION
4608: WHEN OTHERS THEN

Line 4629: FROM oe_order_headers OH,oe_order_lines OL

4625:
4626: --ER#7479609 start
4627: BEGIN
4628: SELECT OH.* INTO l_header_rec
4629: FROM oe_order_headers OH,oe_order_lines OL
4630: WHERE OH.header_id=OL.header_id
4631: AND OL.line_id=l_line_id;
4632:
4633: EXCEPTION

Line 4702: FROM OE_ORDER_HEADERS_ALL

4698: WHERE header_id=l_header_rec.header_id
4699: AND line_id IS NULL
4700: UNION
4701: SELECT payment_type_code payment_type
4702: FROM OE_ORDER_HEADERS_ALL
4703: WHERE header_id=l_header_rec.header_id) V;
4704: EXCEPTION
4705: WHEN OTHERS THEN
4706: null;

Line 5616: FROM OE_ORDER_HEADERS_ALL hdr

5612: AND nvl(src.released_flag, 'N') = 'N')
5613: UNION
5614:
5615: SELECT DISTINCT org_id
5616: FROM OE_ORDER_HEADERS_ALL hdr
5617: WHERE sold_to_org_id = p_hold_entity_id
5618: AND NOT EXISTS (select 1
5619: from oe_hold_sources_all
5620: where hold_entity_id = p_hold_entity_id