VIEW: APPS.INVBV_MOVE_ORDERS_LINES

Source

View Text - Preformatted

SELECT TRL.LINE_ID , TRL.HEADER_ID , TRL.LINE_NUMBER , TRL.ORGANIZATION_ID , TRL.INVENTORY_ITEM_ID , TRL.REVISION , TRL.FROM_SUBINVENTORY_ID , TRL.FROM_SUBINVENTORY_CODE, TRL.FROM_LOCATOR_ID , TRL.TO_SUBINVENTORY_CODE , TRL.TO_SUBINVENTORY_ID , TRL.TO_LOCATOR_ID , TRL.TO_ACCOUNT_ID , TRL.LOT_NUMBER , TRL.SERIAL_NUMBER_START , TRL.SERIAL_NUMBER_END , TRL.UOM_CODE , TRL.QUANTITY , TRL.QUANTITY_DELIVERED , TRL.QUANTITY_DETAILED , TRL.DATE_REQUIRED , TRL.REASON_ID , '_LA:TRL.REFERENCE_TYPE_CODE:MFG_LOOKUPS:MTL_REFERENCE_TYPE:MEANING', TRL.REFERENCE_ID , TRL.PROJECT_ID , TRL.TASK_ID , TRL.TRANSACTION_HEADER_ID , TRL.LINE_STATUS , '_LA:TRL.LINE_STATUS:MFG_LOOKUPS:MTL_TXN_REQUEST_STATUS:MEANING', TRL.STATUS_DATE , TRL.CREATED_BY , TRL.CREATION_DATE , TRL.LAST_UPDATED_BY , TRL.LAST_UPDATE_DATE FROM MTL_TXN_REQUEST_LINES TRL where '_SEC:TRL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT TRL.LINE_ID
, TRL.HEADER_ID
, TRL.LINE_NUMBER
, TRL.ORGANIZATION_ID
, TRL.INVENTORY_ITEM_ID
, TRL.REVISION
, TRL.FROM_SUBINVENTORY_ID
, TRL.FROM_SUBINVENTORY_CODE
, TRL.FROM_LOCATOR_ID
, TRL.TO_SUBINVENTORY_CODE
, TRL.TO_SUBINVENTORY_ID
, TRL.TO_LOCATOR_ID
, TRL.TO_ACCOUNT_ID
, TRL.LOT_NUMBER
, TRL.SERIAL_NUMBER_START
, TRL.SERIAL_NUMBER_END
, TRL.UOM_CODE
, TRL.QUANTITY
, TRL.QUANTITY_DELIVERED
, TRL.QUANTITY_DETAILED
, TRL.DATE_REQUIRED
, TRL.REASON_ID
, '_LA:TRL.REFERENCE_TYPE_CODE:MFG_LOOKUPS:MTL_REFERENCE_TYPE:MEANING'
, TRL.REFERENCE_ID
, TRL.PROJECT_ID
, TRL.TASK_ID
, TRL.TRANSACTION_HEADER_ID
, TRL.LINE_STATUS
, '_LA:TRL.LINE_STATUS:MFG_LOOKUPS:MTL_TXN_REQUEST_STATUS:MEANING'
, TRL.STATUS_DATE
, TRL.CREATED_BY
, TRL.CREATION_DATE
, TRL.LAST_UPDATED_BY
, TRL.LAST_UPDATE_DATE
FROM MTL_TXN_REQUEST_LINES TRL
WHERE '_SEC:TRL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY