Product: | CSP - Spares Management |
---|---|
Description: | Move order lines including extra information of Spares Management |
Implementation/DBA Data: | APPS.CSP_MO_LINES_V |
SELECT CMOL.ROWID
, MTRLV.LINE_ID
, MTRLV.REQUEST_NUMBER
, MTRLV.MOVE_ORDER_TYPE
, MTRLV.MOVE_ORDER_TYPE_NAME
, MTRLV.DESCRIPTION
, MTRLV.HEADER_ID
, MTRLV.TRANSACTION_SOURCE_TYPE_ID
, MTRLV.TRANSACTION_TYPE_ID
, MTRLV.TRANSACTION_TYPE_NAME
, MTRLV.TRANSACTION_ACTION_ID
, MTRLV.LINE_NUMBER
, MTRLV.ORGANIZATION_ID
, MTRLV.INVENTORY_ITEM_ID
, MTRLV.REVISION
, MTRLV.FROM_SUBINVENTORY_ID
, MTRLV.FROM_SUBINVENTORY_CODE
, MTRLV.FROM_SUB_LOCATOR_TYPE
, MTRLV.FROM_SUB_ASSET
, MTRLV.FROM_SUB_QUANTITY_TRACKED
, MTRLV.FROM_SUB_MATERIAL_ACCOUNT
, MTRLV.FROM_LOCATOR_ID
, MTRLV.TO_SUBINVENTORY_CODE
, MTRLV.TO_SUB_LOCATOR_TYPE
, MTRLV.TO_SUB_ASSET
, MTRLV.TO_SUB_QUANTITY_TRACKED
, MTRLV.TO_SUB_MATERIAL_ACCOUNT
, MTRLV.TO_SUBINVENTORY_ID
, MTRLV.TO_LOCATOR_ID
, MTRLV.TO_ACCOUNT_ID
, MTRLV.SHIP_TO_LOCATION_ID
, MTRLV.LOT_NUMBER
, MTRLV.SERIAL_NUMBER_START
, MTRLV.SERIAL_NUMBER_END
, MTRLV.UNIT_NUMBER
, MTRLV.UOM_CODE
, MTRLV.QUANTITY
, MTRLV.QUANTITY_DELIVERED
, MTRLV.QUANTITY_DETAILED
, MTRLV.DATE_REQUIRED
, MTRLV.REASON_ID
, MTRLV.REFERENCE
, MTRLV.REFERENCE_TYPE_CODE
, MTRLV.REFERENCE_ID
, MTRLV.PROJECT_ID
, MTRLV.TASK_ID
, MTRLV.TRANSACTION_HEADER_ID
, MTRLV.LINE_STATUS
, MTRLV.STATUS_DATE
, MTRLV.LAST_UPDATED_BY
, MTRLV.LAST_UPDATE_LOGIN
, MTRLV.LAST_UPDATE_DATE
, MTRLV.CREATED_BY
, MTRLV.CREATION_DATE
, MTRLV.REQUEST_ID
, MTRLV.PROGRAM_APPLICATION_ID
, MTRLV.PROGRAM_ID
, MTRLV.PROGRAM_UPDATE_DATE
, MTRLV.ATTRIBUTE1
, MTRLV.ATTRIBUTE2
, MTRLV.ATTRIBUTE3
, MTRLV.ATTRIBUTE4
, MTRLV.ATTRIBUTE5
, MTRLV.ATTRIBUTE6
, MTRLV.ATTRIBUTE7
, MTRLV.ATTRIBUTE8
, MTRLV.ATTRIBUTE9
, MTRLV.ATTRIBUTE10
, MTRLV.ATTRIBUTE11
, MTRLV.ATTRIBUTE12
, MTRLV.ATTRIBUTE13
, MTRLV.ATTRIBUTE14
, MTRLV.ATTRIBUTE15
, MTRLV.ATTRIBUTE_CATEGORY
, MTRLV.TXN_SOURCE_ID
, MTRLV.TXN_SOURCE_LINE_ID
, MTRLV.TXN_SOURCE_LINE_DETAIL_ID
, MTRLV.PRIMARY_QUANTITY
, MTRLV.TO_ORGANIZATION_ID
, MTRLV.PICK_STRATEGY_ID
, MTRLV.PUT_AWAY_STRATEGY_ID
, MTRLV.FROM_COST_GROUP_ID
, MTRLV.FROM_COST_GROUP_NAME
, MTRLV.TO_COST_GROUP_ID
, MTRLV.TO_COST_GROUP_NAME
, MTRLV.LPN_ID
, MTRLV.TO_LPN_ID
, MTRLV.REFERENCE_DETAIL_ID
, MTRLV.ASSIGNMENT_ID
, MTRLV.LPN_NUMBER
, MTRLV.TO_LPN_NUMBER
, CMOL.INCIDENT_ID
, CIA.INCIDENT_NUMBER
, CMOL.TASK_ID
, JTB.TASK_NUMBER
, CMOL.TASK_ASSIGNMENT_ID
, CMOL.CUSTOMER_PO
, CMOL.COMMENTS
FROM MTL_TXN_REQUEST_LINES_V MTRLV
, CSP_MOVEORDER_LINES CMOL
, CS_INCIDENTS_ALL CIA
, JTF_TASKS_B JTB
WHERE CMOL.HEADER_ID(+) = MTRLV.HEADER_ID
AND CMOL.LINE_ID(+) = MTRLV.LINE_ID
AND CIA.INCIDENT_ID(+) = CMOL.INCIDENT_ID
AND JTB.TASK_ID(+) = CMOL.TASK_ID