APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_ITEM_GROUPS_VL

Line 909: AHL_ITEM_GROUPS_VL ITMGRP

905: CURSOR Get_rec_from_id (c_item_group_id NUMBER)
906: IS
907: SELECT ITMGRP.ITEM_GROUP_ID ITEM_GROUP_ID
908: FROM
909: AHL_ITEM_GROUPS_VL ITMGRP
910: WHERE
911: ITMGRP.STATUS_CODE = 'COMPLETE'AND
912: ITMGRP.ITEM_GROUP_ID = c_item_group_id;
913:

Line 918: AHL_ITEM_GROUPS_VL ITMGRP

914: CURSOR Get_rec_from_value (c_item_group_name VARCHAR2)
915: IS
916: SELECT DISTINCT ITMGRP.ITEM_GROUP_ID ITEM_GROUP_ID
917: FROM
918: AHL_ITEM_GROUPS_VL ITMGRP
919: WHERE
920: ITMGRP.STATUS_CODE = 'COMPLETE'AND
921: ITMGRP.NAME = c_item_group_name;
922:

Line 976: ahl_item_groups_vl aig,

972: CURSOR Get_rec_from_id (c_inventory_item_id NUMBER, c_item_group_id NUMBER, c_organization_id NUMBER)
973: IS
974: SELECT DISTINCT mtl.inventory_item_id
975: FROM mtl_system_items_kfv mtl,
976: ahl_item_groups_vl aig,
977: ahl_item_associations_b ais
978: WHERE mtl.organization_id = c_organization_id --org.organization_id
979: AND nvl(mtl.enabled_flag,'N') = 'Y'
980: AND mtl.inventory_item_flag = 'Y'

Line 993: ahl_item_groups_vl aig,

989: CURSOR Get_rec_from_value (c_concatenated_segments VARCHAR2, c_item_group_id NUMBER, c_organization_id NUMBER)
990: IS
991: SELECT DISTINCT mtl.inventory_item_id
992: FROM mtl_system_items_kfv mtl,
993: ahl_item_groups_vl aig,
994: ahl_item_associations_b ais
995: WHERE mtl.organization_id = c_organization_id --org.organization_id
996: AND nvl(mtl.enabled_flag,'N') = 'Y'
997: AND mtl.inventory_item_flag = 'Y'

Line 1075: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,

1071: AMR.MC_HEADER_ID = AMCR.MC_HEADER_ID AND
1072: NVL(AMCR.ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE AND
1073: AMR.PARENT_RELATIONSHIP_ID IS NULL AND
1074: AMCR.RELATIONSHIP_ID = c_relationship_id
1075: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,
1076: AHL_ITEM_ASSOCIATIONS_B AIS
1077: WHERE
1078: AIG.STATUS_CODE = 'COMPLETE' AND
1079: MC_REL.ITEM_GROUP_ID = AIG.ITEM_GROUP_ID AND

Line 1110: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,

1106: AMR.MC_HEADER_ID = AMCR.MC_HEADER_ID AND
1107: NVL(AMCR.ACTIVE_END_DATE,SYSDATE + 1) > SYSDATE AND
1108: AMR.PARENT_RELATIONSHIP_ID IS NULL AND
1109: AMCR.RELATIONSHIP_ID = c_relationship_id
1110: ) MC_REL, AHL_ITEM_GROUPS_VL AIG, MTL_SYSTEM_ITEMS_KFV MSI,
1111: AHL_ITEM_ASSOCIATIONS_B AIS
1112: WHERE
1113: AIG.STATUS_CODE = 'COMPLETE' AND
1114: MC_REL.ITEM_GROUP_ID = AIG.ITEM_GROUP_ID AND