699: from wip_discrete_jobs wdj,
700: wip_operations wo,
701: wip_operation_resources wor,
702: mtl_uom_conversions muc,
703: bom_department_resources bdr
704: where wdj.wip_entity_id = p_wipEntityID
705: and wdj.organization_id = p_orgID
706: and wdj.wip_entity_id = wo.wip_entity_id
707: and wdj.organization_id = wo.organization_id
757: from wip_discrete_jobs wdj,
758: wsm_copy_operations wco,
759: wsm_copy_op_resources wcor,
760: mtl_uom_conversions muc,
761: bom_department_resources bdr
762: where wdj.wip_entity_id = p_wipEntityID
763: and wdj.organization_id = p_orgID
764: and wdj.wip_entity_id = wco.wip_entity_id
765: and wdj.organization_id = wco.organization_id