[Home] [Help]
| Product: | INV - Inventory |
|---|---|
| Description: | - Retrofitted |
| Implementation/DBA Data: | Not implemented in this database |
SELECT MMOL.MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, MMOL.MOVE_ORDER_HEADER_ID MOVE_ORDER_HEADER_ID
, MMOL.MOVE_ORDER_LINE_NUMBER MOVE_ORDER_LINE_NUMBER
, MMOL.ORGANIZATION_ID ORGANIZATION_ID
, MMOL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MMOL.REVISION REVISION
, MMOL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MMOL.FROM_LOCATOR_ID FROM_LOCATOR_ID
, MMOL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE
, MMOL.TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID
, MMOL.TO_LOCATOR_ID TO_LOCATOR_ID
, MMOL.TO_ACCOUNT_ID TO_ACCOUNT_ID
, MMOL.LOT_NUMBER LOT_NUMBER
, MMOL.SERIAL_NUMBER_START SERIAL_NUMBER_START
, MMOL.SERIAL_NUMBER_END SERIAL_NUMBER_END
, MMOL.UOM_CODE UOM_CODE
, MMOL.UOM_ID UOM_ID
, MMOL.QUANTITY QUANTITY
, MMOL.QUANTITY_DELIVERED QUANTITY_DELIVERED
, MMOL.QUANTITY_DETAILED QUANTITY_DETAILED
, MMOL.DATE_REQUIRED DATE_REQUIRED
, MMOL.REASON_ID REASON_ID
, MMOL.REFERENCE REFERENCE
, MMOL.PROJECT_ID PROJECT_ID
, MMOL.TASK_ID TASK_ID
, MMOL.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MMOL.LINE_APPROVAL_STATUS LINE_APPROVAL_STATUS
, MMOL.STATUS_DATE STATUS_DATE
, MMOL.LAST_UPDATED_BY LAST_UPDATED_BY
, MMOL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MMOL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MMOL.CREATED_BY CREATED_BY
, MMOL.CREATION_DATE CREATION_DATE
, MMOL.REQUEST_ID REQUEST_ID
, MMOL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MMOL.PROGRAM_ID PROGRAM_ID
, MMOL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MMOL.ATTRIBUTE1 ATTRIBUTE1
, MMOL.ATTRIBUTE2 ATTRIBUTE2
, MMOL.ATTRIBUTE3 ATTRIBUTE3
, MMOL.ATTRIBUTE4 ATTRIBUTE4
, MMOL.ATTRIBUTE5 ATTRIBUTE5
, MMOL.ATTRIBUTE6 ATTRIBUTE6
, MMOL.ATTRIBUTE7 ATTRIBUTE7
, MMOL.ATTRIBUTE8 ATTRIBUTE8
, MMOL.ATTRIBUTE9 ATTRIBUTE9
, MMOL.ATTRIBUTE10 ATTRIBUTE10
, MMOL.ATTRIBUTE11 ATTRIBUTE11
, MMOL.ATTRIBUTE12 ATTRIBUTE12
, MMOL.ATTRIBUTE13 ATTRIBUTE13
, MMOL.ATTRIBUTE14 ATTRIBUTE14
, MMOL.ATTRIBUTE15 ATTRIBUTE15
, MMOL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
FROM MTL_MOVE_ORDER_LINES MMOL
, MFG_LOOKUPS MFG
WHERE MFG.LOOKUP_TYPE = 'MTL_MO_LINE_APPROVAL_STATUS'
AND MFG.LOOKUP_CODE = MMOL.LINE_APPROVAL_STATUS