APPS.OE_HOLDS_PUB dependencies on OE_ORDER_HEADERS_ALL

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