DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on WIP_DISCRETE_JOBS

Line 258: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ

254: DECODE(OL.WORKORDER_ID, NULL, HAOU.LOCATION_ID, BOM.LOCATION_ID),
255: WO.WIP_ENTITY_ID,
256: WDJ.PROJECT_ID,
257: WDJ.TASK_ID
258: FROM AHL_OSP_ORDER_LINES OL, AHL_WORKORDERS WO, BOM_DEPARTMENTS BOM, HR_ALL_ORGANIZATION_UNITS HAOU, WIP_DISCRETE_JOBS WDJ
259: WHERE OL.OSP_ORDER_ID = p_osp_order_id AND
260: WO.WORKORDER_ID (+) = OL.WORKORDER_ID AND
261: WDJ.WIP_ENTITY_ID (+) = WO.WIP_ENTITY_ID AND
262: BOM.DEPARTMENT_ID (+) = WDJ.OWNING_DEPARTMENT AND