Product: | CSD - Depot Repair |
---|---|
Description: | The view that is based on CSD_GROUP_JOB_PARAM_TEMP. |
Implementation/DBA Data: | APPS.CSD_GROUP_JOB_PARAM_TEMP_V |
SELECT CROG. ROWID
, CGJP.GROUP_JOB_ID
, CROG. REPAIR_GROUP_ID
, CROG. INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS PRODUCT
, CROG.INCIDENT_ID
, CROG.REPAIR_GROUP_NUMBER
, CGJP.ORGANIZATION_ID
, CGJP.JOB_TYPE
, CGJP.ROUTING_REFERENCE_ID
, CGJP.ALTERNATE_DESIGNATOR_CODE
, CGJP.JOB_STATUS_TYPE
, CGJP.ACCOUNTING_CLASS
, CGJP.START_DATE
, CGJP.COMPLETION_DATE
, CGJP.QUANTITY_RECEIVED
, CGJP.QUANTITY_SUBMITTED
, CGJP.ITEM_REVISION
, CGJP.OBJECT_VERSION_NUMBER
, CGJP.PROCESS_ID
FROM CSD_REPAIR_ORDER_GROUPS CROG
, CSD_REPAIR_TYPES_VL CRT
, MTL_SYSTEM_ITEMS_KFV MSI
, CSD_GROUP_JOB_PARAM_TEMP CGJP
WHERE CROG.REPAIR_TYPE_ID = CRT.REPAIR_TYPE_ID
AND CGJP.REPAIR_GROUP_ID(+) = CROG.REPAIR_GROUP_ID
AND CROG.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CRT.REPAIR_TYPE_REF IN ('RR'
, 'ARR'
, 'WRL'
, 'WR'
, 'SR')
AND CROG.GROUP_APPROVAL_STATUS IN ( 'EST_NOT_REQD'
, 'PARTIAL_APPRD'
, 'APPROVED')
AND CROG.RECEIVED_QUANTITY = CROG.REPAIR_ORDER_QUANTITY
AND CROG.REPAIR_MODE = 'WIP'