[Home] [Help]
1851: FROM wip_parameters
1852: WHERE organization_id = p_org_id;
1853:
1854: CURSOR workorder_released_date_csr(p_wip_entity_id IN NUMBER) IS
1855: SELECT DATE_RELEASED FROM WIP_DISCRETE_JOBS
1856: WHERE WIP_ENTITY_ID = p_wip_entity_id;
1857:
1858: -- Lot Number
1859: CURSOR mtl_lot_num_csr (p_org_id In NUMBER,
4313: (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_JOB_STATUS' AND LANGUAGE= USERENV('LANG')) WO_STS,
4314: AHL_VISITS_B V,
4315: AHL_VISIT_TASKS_B VT,
4316: CS_INCIDENTS_ALL_B C,
4317: WIP_DISCRETE_JOBS WDJ,
4318: (SELECT ORGANIZATION_ID, NAME FROM HR_ALL_ORGANIZATION_UNITS_TL WHERE LANGUAGE = USERENV('LANG')) ORG,
4319: BOM_DEPARTMENTS B,
4320: AHL_WORKORDER_OPERATIONS O,
4321: MTL_UNITS_OF_MEASURE_VL UOM,
4566: AHL_WORKORDERS W,
4567: AHL_VISITS_B V,
4568: AHL_VISIT_TASKS_B VT,
4569: CS_INCIDENTS_ALL_B C,
4570: WIP_DISCRETE_JOBS WDJ,
4571: INV_ORGANIZATION_NAME_V ORG,
4572: BOM_DEPARTMENTS B,
4573: AHL_WORKORDER_OPERATIONS O
4574: WHERE