448: FROM CSD_REPAIR_ORDERS_F RO,
449: CSD_REPAIR_JOB_XREF XREF,
450: WIP_DISCRETE_JOBS DJOB,
451: MTL_MATERIAL_TRANSACTIONS MMT,
452: MTL_SYSTEM_ITEMS_B MSI
453: WHERE RO.status = 'C'
454: AND XREF.repair_line_id = RO.repair_line_id
455: AND XREF.inventory_item_id = RO.inventory_item_id
456: AND DJOB.wip_entity_id = XREF.wip_entity_id
565: FROM CSD_REPAIR_ORDERS_F RO,
566: CSD_REPAIR_JOB_XREF XREF,
567: WIP_DISCRETE_JOBS DJOB,
568: MTL_MATERIAL_TRANSACTIONS MMT,
569: MTL_SYSTEM_ITEMS_B MSI
570: WHERE RO.status = 'C'
571: AND XREF.repair_line_id = RO.repair_line_id
572: AND XREF.inventory_item_id = RO.inventory_item_id
573: AND DJOB.wip_entity_id = XREF.wip_entity_id