DBA Data[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_COMP_V

Line 973: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd

969: -- SELECT 'x'
970: -- FROM ahl_route_effectivities_v
971: -- WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
972: SELECT 'x'
973: FROM ahl_route_effectivities re, AHL_ITEM_COMP_V icd
974: WHERE icd.ITEM_COMPOSITION_ID = p_item_composition_id
975: AND re.inventory_item_id = ICD.inventory_item_id
976: AND re.INVENTORY_MASTER_ORG_ID = ICD.INVENTORY_MASTER_ORG_ID
977: AND ICD.APPROVAL_STATUS_CODE = 'COMPLETE';

Line 1624: From ahl_item_comp_v

1620: Select item_composition_id,
1621: approval_status_code,
1622: object_version_number,
1623: concatenated_segments
1624: From ahl_item_comp_v
1625: Where item_composition_id = c_item_comp_id;
1626:
1627:
1628: