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_COMPLEX_MX_PVT dependencies on FND_PROFILE

Line 581: AND nr.incident_type_id =fnd_profile.value('AHL_REMOVAL_NON_ROUTINE') -- Removal NR type Id

577: FROM ahl_unit_effectivities_b ue,
578: CS_INCIDENTS_ALL_B nr
579: WHERE ue.csi_item_instance_id =c_instance_id
580: AND ue.cs_incident_id =nr.incident_id
581: AND nr.incident_type_id =fnd_profile.value('AHL_REMOVAL_NON_ROUTINE') -- Removal NR type Id
582: AND ue.object_type ='SR'
583: AND ue.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE')
584: AND NVL(ue.status_code,'INIT-DUE') = 'INIT-DUE';
585:

Line 583: AND ue.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE')

579: WHERE ue.csi_item_instance_id =c_instance_id
580: AND ue.cs_incident_id =nr.incident_id
581: AND nr.incident_type_id =fnd_profile.value('AHL_REMOVAL_NON_ROUTINE') -- Removal NR type Id
582: AND ue.object_type ='SR'
583: AND ue.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE')
584: AND NVL(ue.status_code,'INIT-DUE') = 'INIT-DUE';
585:
586: BEGIN
587: l_removal_nr_due:=NULL;

Line 620: AND B.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE')

616: ahl_mr_headers_b mr
617: WHERE B.mr_header_id =mr.mr_header_id
618: AND NVL(mr.service_type_code,'ASR') = 'ASR'
619: AND B.object_type ='MR'
620: AND B.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE')
621: AND NVL(B.status_code,'INIT-DUE') = 'INIT-DUE'
622: --AND B.preceding_ue_id IS NULL
623: AND B.csi_item_instance_id IN
624: (SELECT subject_id