VIEW: APPS.CSP_MO_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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