eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_MC_CONFIG_RELATIONS

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 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