APPS.OE_HOLDS_PVT dependencies on OE_SHIP_FROM_ORGS_V

Line 160: from oe_ship_from_orgs_v

156: where ORGANIZATION_ID = p_hold_entity_id;
157:
158: CURSOR ship_from_value_cur IS
159: select name
160: from oe_ship_from_orgs_v
161: where ORGANIZATION_ID = p_hold_entity_id;
162:
163: --ER#7479609 start
164: CURSOR deliver_to_value_cur IS

Line 2453: from oe_ship_from_orgs_v

2449: --ER# 13331078 end
2450: ELSIF p_hold_source_rec.hold_entity_code = 'W' THEN
2451: SELECT 'Valid Entity'
2452: INTO l_dummy
2453: from oe_ship_from_orgs_v
2454: where ORGANIZATION_id = p_hold_source_rec.hold_entity_id;
2455: ELSIF p_hold_source_rec.hold_entity_code = 'H' THEN
2456: SELECT 'Valid Entity'
2457: INTO l_dummy

Line 2595: from oe_ship_from_orgs_v

2591: AND LINE_NUMBER = p_hold_source_rec.hold_entity_id2;
2592: ELSIF p_hold_source_rec.hold_entity_code2 = 'W' THEN
2593: SELECT 'Valid Entity'
2594: INTO l_dummy
2595: from oe_ship_from_orgs_v
2596: where ORGANIZATION_id = p_hold_source_rec.hold_entity_id2;
2597: --ER#7479609 start
2598: ELSIF p_hold_source_rec.hold_entity_code2 = 'CB' THEN
2599: SELECT 'Valid Entity'