DBA Data[Home] [Help]

APPS.CSD_HVR_BI_PVT dependencies on WIP_DISCRETE_JOBS

Line 450: WIP_DISCRETE_JOBS DJOB,

446: l_program_application_id,
447: l_request_id
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

Line 567: WIP_DISCRETE_JOBS DJOB,

563: (-1 * ABS(mmt.primary_quantity))))) PRIMARY_QUANTITY,
564: MSI.primary_uom_code PRIMARY_UOM_CODE
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

Line 727: WIP_DISCRETE_JOBS DJOB,

723: l_program_application_id,
724: l_request_id
725: FROM CSD_REPAIR_ORDERS_F RO,
726: CSD_REPAIR_JOB_XREF XREF,
727: WIP_DISCRETE_JOBS DJOB,
728: WIP_TRANSACTIONS WTXN
729: WHERE RO.status = 'C'
730: AND XREF.repair_line_id = RO.repair_line_id
731: AND XREF.inventory_item_id = RO.inventory_item_id

Line 832: WIP_DISCRETE_JOBS DJOB,

828: SUM(NVL(WTXN.primary_quantity, 0)) primary_quantity,
829: WTXN.primary_uom primary_uom_code
830: FROM CSD_REPAIR_ORDERS_F RO,
831: CSD_REPAIR_JOB_XREF XREF,
832: WIP_DISCRETE_JOBS DJOB,
833: WIP_TRANSACTIONS WTXN
834: WHERE RO.status = 'C'
835: AND XREF.repair_line_id = RO.repair_line_id
836: AND XREF.inventory_item_id = RO.inventory_item_id