DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2013: HR_ALL_ORGANIZATION_UNITS HROU

2009: ||TO_CHAR(WIP.DATE_RELEASED, 'hh24:mi:ss') ) DATE_RELEASED
2010: FROM AHL_WORKORDERS WO ,
2011: WIP_DISCRETE_JOBS WIP ,
2012: AHL_VISITS_B VST ,
2013: HR_ALL_ORGANIZATION_UNITS HROU
2014: WHERE WO.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
2015: AND VST.ORGANIZATION_ID = HROU.ORGANIZATION_ID
2016: AND WO.VISIT_ID = VST.VISIT_ID
2017: AND WO.WORKORDER_ID = c_wo_id;

Line 2972: HR_ALL_ORGANIZATION_UNITS HROU,

2968: FROM AHL_VISITS_B AVB,
2969: MTL_SYSTEM_ITEMS_B_KFV MTSB,
2970: CSI_ITEM_INSTANCES CSIS,
2971: FND_LOOKUP_VALUES_VL FLVT,
2972: HR_ALL_ORGANIZATION_UNITS HROU,
2973: BOM_DEPARTMENTS BDPT,
2974: mtl_item_locations_kfv MTLI,
2975: mtl_item_locations MSI
2976: WHERE VISIT_ID = :1