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_RA_ANALYSER_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 84: -- Perf Fix -- MTL_SYSTEM_ITEMS need not be used here as DESCRIPTION can be fetched from MTL_SYSTEM_ITEMS_KFV

80: -- Comment Here Ends
81: */
82:
83: /* -- Bug 4777658 : Perf Fix : Rewriting cursor c_uc_node_details below.
84: -- Perf Fix -- MTL_SYSTEM_ITEMS need not be used here as DESCRIPTION can be fetched from MTL_SYSTEM_ITEMS_KFV
85: CURSOR c_uc_node_details(c_csi_instance_id csi_ii_relationships.object_id%TYPE) IS
86: SELECT CIIR.OBJECT_ID, -- l_dtls_object_id_tbl
87: CIIR.SUBJECT_ID, -- l_dtls_subject_id_tbl
88: DECODE(UC.CSI_ITEM_INSTANCE_ID,

Line 107: MTL_SYSTEM_ITEMS_KFV KFV,

103: KFV.DESCRIPTION -- l_dtls_item_desc_tbl
104: FROM CSI_II_RELATIONSHIPS CIIR,
105: CSI_ITEM_INSTANCES CII,
106: --MTL_SYSTEM_ITEMS MSI,
107: MTL_SYSTEM_ITEMS_KFV KFV,
108: AHL_UNIT_CONFIG_HEADERS UC
109: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
110: AND CII.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
111: AND CII.INV_MASTER_ORGANIZATION_ID = KFV.ORGANIZATION_ID

Line 172: MTL_SYSTEM_ITEMS_KFV KFV,

168: AND CIIRI.RELATIONSHIP_TYPE_CODE = 'COMPONENT-OF'
169: AND TRUNC(NVL(CIIRI.ACTIVE_START_DATE,SYSDATE)) <= TRUNC(SYSDATE)
170: AND TRUNC(SYSDATE) < TRUNC(NVL(CIIRI.ACTIVE_END_DATE,SYSDATE+1))) CIIR,
171: CSI_ITEM_INSTANCES CII,
172: MTL_SYSTEM_ITEMS_KFV KFV,
173: AHL_UNIT_CONFIG_HEADERS UC,
174: AHL_UNIT_CONFIG_HEADERS UCI
175: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
176: AND CII.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID

Line 275: l_root_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

271: l_root_inv_item_id CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE;
272: l_root_inv_master_org_id CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID%TYPE;
273: l_root_item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
274: l_root_srl_no CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE;
275: l_root_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
276: l_root_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
277:
278:
279: -- Table Type to retrieve Counters Associated to a Item Instance.

Line 276: l_root_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;

272: l_root_inv_master_org_id CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID%TYPE;
273: l_root_item_revision CSI_ITEM_INSTANCES.INVENTORY_REVISION%TYPE;
274: l_root_srl_no CSI_ITEM_INSTANCES.SERIAL_NUMBER%TYPE;
275: l_root_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
276: l_root_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
277:
278:
279: -- Table Type to retrieve Counters Associated to a Item Instance.
280: l_ctr_values_tbl AHL_UMP_PROCESSUNIT_PVT.counter_values_tbl_type;

Line 698: MTL_SYSTEM_ITEMS_KFV KFV,

694: l_root_item_name,
695: l_root_item_desc
696: FROM AHL_UNIT_CONFIG_HEADERS UC,
697: CSI_ITEM_INSTANCES CII,
698: MTL_SYSTEM_ITEMS_KFV KFV,
699: ahl_mc_relationships MCR
700: WHERE UC.UNIT_CONFIG_HEADER_ID = l_fs_uc_header_id_tbl(i)
701: AND UC.CSI_ITEM_INSTANCE_ID = CII.INSTANCE_ID
702: AND KFV.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID