DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on OE_SOLD_TO_ORGS_V

Line 2391: FROM oe_sold_to_orgs_v

2387: -- ELSIF p_hold_source_rec.hold_entity_code = 'C' THEN --ER# 11824468
2388: ELSIF p_hold_source_rec.hold_entity_code IN ('C','CN','EC','EN') THEN --ER# 11824468 --ER#12571983 added ,'EC','EN'
2389: SELECT 'Valid Entity'
2390: INTO l_dummy
2391: FROM oe_sold_to_orgs_v
2392: WHERE ORGANIZATION_ID = p_hold_source_rec.hold_entity_id;
2393:
2394: /* Following cursor has been changed to use direct TCA tables -Bug 1874065*/
2395: /*

Line 2537: FROM oe_sold_to_orgs_v

2533: ELSIF p_hold_source_rec.hold_entity_code2 IN('C','CN','EC','EN') THEN --ER# 11824468 --ER#12571983 added ,'EC','EN'
2534:
2535: SELECT 'Valid Entity'
2536: INTO l_dummy
2537: FROM oe_sold_to_orgs_v
2538: WHERE ORGANIZATION_ID = p_hold_source_rec.hold_entity_id2;
2539:
2540: /* Following cursor has been changed to use direct TCA tables -Bug 1874065*/
2541: /* ELSIF p_hold_source_rec.hold_entity_code2 = 'S' THEN