APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_MR_INSTANCES_TEMP

Line 13688: FROM csi_item_instances cii, ahl_mr_instances_temp mr

13684: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
13685: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
13686: ) Root_instance_id
13687:
13688: FROM csi_item_instances cii, ahl_mr_instances_temp mr
13689: WHERE trunc(nvl(cii.active_start_date, sysdate)) <= trunc(sysdate) AND
13690: trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))
13691: AND mr.item_instance_id = cii.instance_id
13692: )

Line 13748: FROM csi_item_instances cii,ahl_mr_instances_temp mr

13744: trunc(nvl(parent.active_start_date, sysdate)) <= trunc(sysdate) and
13745: trunc(sysdate) < trunc(nvl(parent.active_end_date, sysdate+1))
13746: ) Root_instance_id
13747:
13748: FROM csi_item_instances cii,ahl_mr_instances_temp mr
13749: WHERE trunc(nvl(cii.active_start_date, sysdate)) <= trunc(sysdate) AND
13750: trunc(sysdate) < trunc(nvl(cii.active_end_date, sysdate+1))
13751: AND mr.item_instance_id = cii.instance_id
13752: )

Line 13823: FROM ahl_mr_instances_temp

13819: FROM ahl_unit_effectivities_app_v UE
13820: WHERE UE.mr_header_id = p_mr_header_id
13821: AND (UE.status_code IS NULL OR UE.status_code IN ('INIT-DUE','EXCEPTION'))
13822: AND NOT EXISTS (Select 1
13823: FROM ahl_mr_instances_temp
13824: WHERE item_instance_id = ue.csi_item_instance_id)
13825: )
13826: ) valid_inst
13827: WHERE NOT EXISTS (Select 1

Line 13861: -- this API will insert the applicable MRs into temp table ahl_mr_instances_temp

13857: -- initialize return status.
13858: x_return_status := FND_API.G_RET_STS_SUCCESS;
13859:
13860: -- get instances applicable to the MR.
13861: -- this API will insert the applicable MRs into temp table ahl_mr_instances_temp
13862: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS (
13863: p_api_version => 1.0,
13864: p_init_msg_list => FND_API.G_TRUE,
13865: x_return_status => x_return_status,