APPS.OE_HOLDS_PUB dependencies on OE_ORDER_HEADERS_ALL

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 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 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