APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_MC_RELATIONSHIPS

Line 831: AHL_MC_RELATIONSHIPS AMR,

827: IS
828: SELECT DISTINCT
829: AMR.POSITION_KEY, AMR.RELATIONSHIP_ID
830: FROM
831: AHL_MC_RELATIONSHIPS AMR,
832: FND_LOOKUP_VALUES_VL FLV
833: WHERE
834: AMR.POSITION_REF_CODE = FLV.LOOKUP_CODE AND
835: NVL(AMR.ACTIVE_END_DATE,SYSDATE +1 ) > SYSDATE AND

Line 846: AHL_MC_RELATIONSHIPS AMR,

842: IS
843: SELECT DISTINCT
844: AMR.POSITION_KEY, AMR.RELATIONSHIP_ID
845: FROM
846: AHL_MC_RELATIONSHIPS AMR,
847: FND_LOOKUP_VALUES_VL FLV
848: WHERE
849: AMR.POSITION_REF_CODE = FLV.LOOKUP_CODE AND
850: NVL(AMR.ACTIVE_END_DATE,SYSDATE +1 ) > SYSDATE AND

Line 1063: AHL_MC_RELATIONSHIPS

1059: FROM
1060: (SELECT RELATIONSHIP_ID PARENT_REL_ID,RELATIONSHIP_ID CHILD_REL_ID, MC_HEADER_ID MC_HEADER_ID,
1061: ITEM_GROUP_ID, POSITION_REF_CODE, POSITION_KEY
1062: FROM
1063: AHL_MC_RELATIONSHIPS
1064: WHERE RELATIONSHIP_ID = c_relationship_id
1065: UNION
1066: SELECT AMCR.RELATIONSHIP_ID PARENT_REL_ID, AMR.RELATIONSHIP_ID CHILD_REL_ID,
1067: AMCR.MC_HEADER_ID MC_HEADER_ID,

Line 1069: FROM AHL_MC_RELATIONSHIPS AMR, AHL_MC_CONFIG_RELATIONS AMCR

1065: UNION
1066: SELECT AMCR.RELATIONSHIP_ID PARENT_REL_ID, AMR.RELATIONSHIP_ID CHILD_REL_ID,
1067: AMCR.MC_HEADER_ID MC_HEADER_ID,
1068: AMR.ITEM_GROUP_ID CHILD_ITEM_GROUP_ID,AMR.POSITION_REF_CODE,AMR.POSITION_KEY
1069: FROM AHL_MC_RELATIONSHIPS AMR, AHL_MC_CONFIG_RELATIONS AMCR
1070: WHERE
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

Line 1098: AHL_MC_RELATIONSHIPS

1094: FROM
1095: (SELECT RELATIONSHIP_ID PARENT_REL_ID,RELATIONSHIP_ID CHILD_REL_ID, MC_HEADER_ID MC_HEADER_ID,
1096: ITEM_GROUP_ID, POSITION_REF_CODE, POSITION_KEY
1097: FROM
1098: AHL_MC_RELATIONSHIPS
1099: WHERE RELATIONSHIP_ID = c_relationship_id
1100: UNION
1101: SELECT AMCR.RELATIONSHIP_ID PARENT_REL_ID, AMR.RELATIONSHIP_ID CHILD_REL_ID,
1102: AMCR.MC_HEADER_ID MC_HEADER_ID,

Line 1104: FROM AHL_MC_RELATIONSHIPS AMR, AHL_MC_CONFIG_RELATIONS AMCR

1100: UNION
1101: SELECT AMCR.RELATIONSHIP_ID PARENT_REL_ID, AMR.RELATIONSHIP_ID CHILD_REL_ID,
1102: AMCR.MC_HEADER_ID MC_HEADER_ID,
1103: AMR.ITEM_GROUP_ID CHILD_ITEM_GROUP_ID,AMR.POSITION_REF_CODE,AMR.POSITION_KEY
1104: FROM AHL_MC_RELATIONSHIPS AMR, AHL_MC_CONFIG_RELATIONS AMCR
1105: WHERE
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