APPS.OE_HOLDS_PVT dependencies on OE_SHIP_FROM_ORGS_V

Line 106: from oe_ship_from_orgs_v

102: where ORGANIZATION_ID = p_hold_entity_id;
103:
104: CURSOR ship_from_value_cur IS
105: select name
106: from oe_ship_from_orgs_v
107: where ORGANIZATION_ID = p_hold_entity_id;
108:
109: --ER#7479609 start
110: CURSOR deliver_to_value_cur IS

Line 2008: from oe_ship_from_orgs_v

2004: where inventory_item_id = p_hold_source_rec.hold_entity_id;
2005: ELSIF p_hold_source_rec.hold_entity_code = 'W' THEN
2006: SELECT 'Valid Entity'
2007: INTO l_dummy
2008: from oe_ship_from_orgs_v
2009: where ORGANIZATION_id = p_hold_source_rec.hold_entity_id;
2010: ELSIF p_hold_source_rec.hold_entity_code = 'H' THEN
2011: SELECT 'Valid Entity'
2012: INTO l_dummy

Line 2140: from oe_ship_from_orgs_v

2136: AND LINE_NUMBER = p_hold_source_rec.hold_entity_id2;
2137: ELSIF p_hold_source_rec.hold_entity_code2 = 'W' THEN
2138: SELECT 'Valid Entity'
2139: INTO l_dummy
2140: from oe_ship_from_orgs_v
2141: where ORGANIZATION_id = p_hold_source_rec.hold_entity_id2;
2142: --ER#7479609 start
2143: ELSIF p_hold_source_rec.hold_entity_code2 = 'CB' THEN
2144: SELECT 'Valid Entity'