APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1196: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)
1197: AND AVTS.ITEM_INSTANCE_ID = CSIS.INSTANCE_ID(+)
1198: AND AVTS.ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)
1199: AND AVTS.DEPARTMENT_ID = BDPT.DEPARTMENT_ID(+)

Line 1248: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB

1244: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1245: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1246: -- SKPATHAK :: Bug #8983097 :: 20-OCT-2009
1247: --PA_PROJECTS_ALL PA,
1248: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1249: WHERE AVTS.VISIT_ID = AVTSTL.VISIT_ID
1250: AND AVTSTL.LANGUAGE = USERENV('LANG')
1251: AND ASPV.SIMULATION_PLAN_ID = ASPVTL.SIMULATION_PLAN_ID(+)
1252: AND ASPVTL.LANGUAGE(+) = USERENV('LANG')

Line 1318: SELECT name, UNIT_CONFIG_HEADER_ID FROM ahl_unit_config_headers

1314: SELECT name FROM PA_PROJECTS_ALL
1315: WHERE project_id = p_proj_temp_id;
1316:
1317: CURSOR c_uc_header(x_instance_id IN NUMBER) IS
1318: SELECT name, UNIT_CONFIG_HEADER_ID FROM ahl_unit_config_headers
1319: WHERE CSI_ITEM_INSTANCE_ID = x_instance_id
1320: AND active_end_date is null;
1321:
1322: --PRAKKUM ::FP PIE :: 13-OCT-2010

Line 1714: ahl_unit_config_headers uc,

1710: csis.instance_id,
1711: mtl.inventory_item_id ,
1712: mtl.inventory_org_id
1713: FROM ahl_mtl_items_ou_v mtl,
1714: ahl_unit_config_headers uc,
1715: csi_item_instances csis
1716: WHERE uc.name = p_unit_name
1717: AND uc.csi_item_instance_id=csis.instance_id
1718: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID) in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')

Line 1732: ahl_unit_config_headers uc,

1728: mtl.inventory_item_id ,
1729: --mtl.inventory_org_id
1730: csis.inv_master_organization_id
1731: FROM mtl_system_items_kfv mtl,
1732: ahl_unit_config_headers uc,
1733: csi_item_instances csis
1734: WHERE uc.name = p_unit_name
1735: AND uc.csi_item_instance_id=csis.instance_id
1736: AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')

Line 1755: ahl_unit_config_headers uc,

1751: csis.instance_id,
1752: mtl.inventory_item_id ,
1753: csis.inv_master_organization_id
1754: FROM mtl_system_items mtl,
1755: ahl_unit_config_headers uc,
1756: csi_item_instances csis
1757: WHERE uc.name = p_unit_name
1758: AND uc.csi_item_instance_id=csis.instance_id
1759: -- Fix by jaramana on June 27, 2006 for Bug 5360066