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.

APPS.AHL_MC_TREE_PVT dependencies on FND_LOOKUP_VALUES

Line 698: FND_LOOKUP_VALUES FPRC,

694: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
695: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
696: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
697: ) HDR,
698: FND_LOOKUP_VALUES FPRC,
699: FND_LOOKUP_VALUES FPNC,
700: FND_LOOKUP_VALUES FATA
701: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
702: AND REL.MC_HEADER_ID = p_mc_header_id

Line 699: FND_LOOKUP_VALUES FPNC,

695: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
696: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
697: ) HDR,
698: FND_LOOKUP_VALUES FPRC,
699: FND_LOOKUP_VALUES FPNC,
700: FND_LOOKUP_VALUES FATA
701: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
702: AND REL.MC_HEADER_ID = p_mc_header_id
703: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID

Line 700: FND_LOOKUP_VALUES FATA

696: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
697: ) HDR,
698: FND_LOOKUP_VALUES FPRC,
699: FND_LOOKUP_VALUES FPNC,
700: FND_LOOKUP_VALUES FATA
701: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
702: AND REL.MC_HEADER_ID = p_mc_header_id
703: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
704: AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)

Line 745: FND_LOOKUP_VALUES FPRC,

741: DECODE (SIGN(TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE+1)) - TRUNC(SYSDATE)),
742: 1, HDR.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
743: FROM AHL_MC_RELATIONSHIPS REL,
744: AHL_MC_HEADERS_B HDR,
745: FND_LOOKUP_VALUES FPRC,
746: FND_LOOKUP_VALUES FPNC,
747: FND_LOOKUP_VALUES FATA
748: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
749: AND REL.MC_HEADER_ID = p_mc_header_id

Line 746: FND_LOOKUP_VALUES FPNC,

742: 1, HDR.CONFIG_STATUS_CODE, 'EXPIRED')) CONFIG_STATUS_CODE
743: FROM AHL_MC_RELATIONSHIPS REL,
744: AHL_MC_HEADERS_B HDR,
745: FND_LOOKUP_VALUES FPRC,
746: FND_LOOKUP_VALUES FPNC,
747: FND_LOOKUP_VALUES FATA
748: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
749: AND REL.MC_HEADER_ID = p_mc_header_id
750: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID

Line 747: FND_LOOKUP_VALUES FATA

743: FROM AHL_MC_RELATIONSHIPS REL,
744: AHL_MC_HEADERS_B HDR,
745: FND_LOOKUP_VALUES FPRC,
746: FND_LOOKUP_VALUES FPNC,
747: FND_LOOKUP_VALUES FATA
748: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
749: AND REL.MC_HEADER_ID = p_mc_header_id
750: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
751: AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE

Line 800: FND_LOOKUP_VALUES FPRC,

796: FROM AHL_MC_HEADERS_B MCB, AHL_MC_RELATIONSHIPS MCR
797: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
798: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
799: ) HDR,
800: FND_LOOKUP_VALUES FPRC,
801: FND_LOOKUP_VALUES FPNC,
802: FND_LOOKUP_VALUES FATA
803: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
804: AND REL.MC_HEADER_ID = p_mc_header_id

Line 801: FND_LOOKUP_VALUES FPNC,

797: WHERE MCB.MC_HEADER_ID = MCR.MC_HEADER_ID
798: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
799: ) HDR,
800: FND_LOOKUP_VALUES FPRC,
801: FND_LOOKUP_VALUES FPNC,
802: FND_LOOKUP_VALUES FATA
803: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
804: AND REL.MC_HEADER_ID = p_mc_header_id
805: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID

Line 802: FND_LOOKUP_VALUES FATA

798: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
799: ) HDR,
800: FND_LOOKUP_VALUES FPRC,
801: FND_LOOKUP_VALUES FPNC,
802: FND_LOOKUP_VALUES FATA
803: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
804: AND REL.MC_HEADER_ID = p_mc_header_id
805: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
806: AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)

Line 852: FND_LOOKUP_VALUES_VL FPRC,

848: HDR.VERSION_NUMBER,
849: HDR.CONFIG_STATUS_CODE
850: FROM AHL_MC_RELATIONSHIPS REL,
851: AHL_MC_HEADERS_V HDR,
852: FND_LOOKUP_VALUES_VL FPRC,
853: FND_LOOKUP_VALUES_VL FPNC,
854: FND_LOOKUP_VALUES_VL FATA
855: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
856: AND REL.MC_HEADER_ID = p_mc_header_id

Line 853: FND_LOOKUP_VALUES_VL FPNC,

849: HDR.CONFIG_STATUS_CODE
850: FROM AHL_MC_RELATIONSHIPS REL,
851: AHL_MC_HEADERS_V HDR,
852: FND_LOOKUP_VALUES_VL FPRC,
853: FND_LOOKUP_VALUES_VL FPNC,
854: FND_LOOKUP_VALUES_VL FATA
855: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
856: AND REL.MC_HEADER_ID = p_mc_header_id
857: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID

Line 854: FND_LOOKUP_VALUES_VL FATA

850: FROM AHL_MC_RELATIONSHIPS REL,
851: AHL_MC_HEADERS_V HDR,
852: FND_LOOKUP_VALUES_VL FPRC,
853: FND_LOOKUP_VALUES_VL FPNC,
854: FND_LOOKUP_VALUES_VL FATA
855: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_relationship_id,0)
856: AND REL.MC_HEADER_ID = p_mc_header_id
857: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
858: AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)

Line 899: FND_LOOKUP_VALUES_VL FPRC,

895: HDR.VERSION_NUMBER,
896: HDR.CONFIG_STATUS_CODE
897: FROM AHL_MC_RELATIONSHIPS REL,
898: AHL_MC_HEADERS_V HDR,
899: FND_LOOKUP_VALUES_VL FPRC,
900: FND_LOOKUP_VALUES_VL FPNC,
901: FND_LOOKUP_VALUES_VL FATA
902: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
903: AND REL.MC_HEADER_ID = p_mc_header_id

Line 900: FND_LOOKUP_VALUES_VL FPNC,

896: HDR.CONFIG_STATUS_CODE
897: FROM AHL_MC_RELATIONSHIPS REL,
898: AHL_MC_HEADERS_V HDR,
899: FND_LOOKUP_VALUES_VL FPRC,
900: FND_LOOKUP_VALUES_VL FPNC,
901: FND_LOOKUP_VALUES_VL FATA
902: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
903: AND REL.MC_HEADER_ID = p_mc_header_id
904: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID

Line 901: FND_LOOKUP_VALUES_VL FATA

897: FROM AHL_MC_RELATIONSHIPS REL,
898: AHL_MC_HEADERS_V HDR,
899: FND_LOOKUP_VALUES_VL FPRC,
900: FND_LOOKUP_VALUES_VL FPNC,
901: FND_LOOKUP_VALUES_VL FATA
902: WHERE REL.PARENT_RELATIONSHIP_ID IS NULL
903: AND REL.MC_HEADER_ID = p_mc_header_id
904: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
905: AND FPRC.LOOKUP_CODE (+) = REL.POSITION_REF_CODE

Line 941: FND_LOOKUP_VALUES_VL FPRC,

937: HDR.VERSION_NUMBER,
938: HDR.CONFIG_STATUS_CODE
939: FROM AHL_MC_RELATIONSHIPS REL,
940: AHL_MC_HEADERS_V HDR,
941: FND_LOOKUP_VALUES_VL FPRC,
942: FND_LOOKUP_VALUES_VL FPNC,
943: FND_LOOKUP_VALUES_VL FATA
944: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
945: AND REL.MC_HEADER_ID = p_mc_header_id

Line 942: FND_LOOKUP_VALUES_VL FPNC,

938: HDR.CONFIG_STATUS_CODE
939: FROM AHL_MC_RELATIONSHIPS REL,
940: AHL_MC_HEADERS_V HDR,
941: FND_LOOKUP_VALUES_VL FPRC,
942: FND_LOOKUP_VALUES_VL FPNC,
943: FND_LOOKUP_VALUES_VL FATA
944: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
945: AND REL.MC_HEADER_ID = p_mc_header_id
946: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID

Line 943: FND_LOOKUP_VALUES_VL FATA

939: FROM AHL_MC_RELATIONSHIPS REL,
940: AHL_MC_HEADERS_V HDR,
941: FND_LOOKUP_VALUES_VL FPRC,
942: FND_LOOKUP_VALUES_VL FPNC,
943: FND_LOOKUP_VALUES_VL FATA
944: WHERE NVL(REL.PARENT_RELATIONSHIP_ID,0) = NVL(p_parent_rel_id,0)
945: AND REL.MC_HEADER_ID = p_mc_header_id
946: AND REL.MC_HEADER_ID = HDR.MC_HEADER_ID
947: AND TRUNC(NVL(REL.ACTIVE_END_DATE, SYSDATE + 1)) > TRUNC(SYSDATE)