VIEW: APPS.CSD_RO_GROUP_JOBS_V

Source

View Text - Preformatted

SELECT crjx.rowid, crog.repair_group_id, we.wip_entity_name, crjx.group_id, crjx.organization_id, crjx.quantity, crjx.quantity_completed, wdj.start_quantity, ml.meaning status, msi.concatenated_segments router, hou.name organization_name from csd_repair_order_groups crog, csd_repairs cr, csd_repair_job_xref crjx, wip_entities we, wip_discrete_jobs wdj, mfg_lookups ml, mtl_system_items_kfv msi, hr_organization_units hou WHERE crog.repair_group_id = cr.repair_group_id and cr.repair_line_id = crjx.repair_line_id and crjx.wip_entity_id = we.wip_entity_id and crjx.organization_id = we.organization_id and crjx.organization_id = hou.organization_id and we.wip_entity_id = wdj.wip_entity_id and wdj.status_type = ml.lookup_code and ml.lookup_type = 'WIP_JOB_STATUS' and wdj.routing_reference_id = msi.inventory_item_id(+) and wdj.organization_id = msi.organization_id(+)

View Text - HTML Formatted

SELECT CRJX.ROWID
, CROG.REPAIR_GROUP_ID
, WE.WIP_ENTITY_NAME
, CRJX.GROUP_ID
, CRJX.ORGANIZATION_ID
, CRJX.QUANTITY
, CRJX.QUANTITY_COMPLETED
, WDJ.START_QUANTITY
, ML.MEANING STATUS
, MSI.CONCATENATED_SEGMENTS ROUTER
, HOU.NAME ORGANIZATION_NAME
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CSD_REPAIRS CR
, CSD_REPAIR_JOB_XREF CRJX
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, MFG_LOOKUPS ML
, MTL_SYSTEM_ITEMS_KFV MSI
, HR_ORGANIZATION_UNITS HOU
WHERE CROG.REPAIR_GROUP_ID = CR.REPAIR_GROUP_ID
AND CR.REPAIR_LINE_ID = CRJX.REPAIR_LINE_ID
AND CRJX.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND CRJX.ORGANIZATION_ID = WE.ORGANIZATION_ID
AND CRJX.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND WDJ.ROUTING_REFERENCE_ID = MSI.INVENTORY_ITEM_ID(+)
AND WDJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)