DBA Data[Home] [Help]

APPS.AHL_RA_SETUPS_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 649: FROM ahl_mc_relationships

645: SELECT 'Y'
646: INTO l_dummy
647: FROM dual
648: WHERE EXISTS(SELECT 'X'
649: FROM ahl_mc_relationships
650: WHERE mc_header_id = l_ra_def_hdr_rec.MC_HEADER_ID
651: AND relationship_id = l_ra_def_hdr_rec.RELATIONSHIP_ID);
652:
653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 675: FROM ahl_mc_relationships mcr, ahl_item_associations_b ia

671: SELECT 'Y'
672: INTO l_dummy
673: FROM dual
674: WHERE EXISTS(SELECT 'X'
675: FROM ahl_mc_relationships mcr, ahl_item_associations_b ia
676: WHERE mcr.relationship_id = l_ra_def_hdr_rec.RELATIONSHIP_ID
677: AND mcr.item_group_id = ia.item_group_id
678: AND ia.inventory_item_id = l_ra_def_hdr_rec.INVENTORY_ITEM_ID
679: AND ia.inventory_org_id = l_ra_def_hdr_rec.INVENTORY_ORG_ID