VIEW: APPS.CSD_GROUP_JOB_PARAM_TEMP_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'