Product: | GMI - Process Manufacturing Inventory |
---|---|
Description: | This view is used in the OPM Transact Process Move Orders form (ICTOTRX.fmb) to get the Move Order Lines data based on the entered criteria. |
Implementation/DBA Data: | APPS.IC_TXN_REQUEST_LINES_V |
SELECT MOL.LINE_ID LINE_ID
, MOH.REQUEST_NUMBER REQUEST_NUMBER
, MOH.MOVE_ORDER_TYPE MOVE_ORDER_TYPE
, MFG.MEANING MOVE_ORDER_TYPE_NAME
, MOH.DESCRIPTION DESCRIPTION
, MOL.HEADER_ID HEADER_ID
, MOL.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, MOL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME
, MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, MOL.LINE_NUMBER LINE_NUMBER
, MOL.ORGANIZATION_ID ORGANIZATION_ID
, MOL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MOL.FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID
, MOL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE
, MOL.FROM_LOCATOR_ID FROM_LOCATOR_ID
, MOL.TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID
, MOL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE
, MOL.TO_LOCATOR_ID TO_LOCATOR_ID
, MOL.TO_ACCOUNT_ID TO_ACCOUNT_ID
, MOL.SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, MOL.LOT_NO LOT_NUMBER
, MOL.SUBLOT_NO SUBLOT_NO
, MOL.UOM_CODE UOM_CODE
, MOL.QUANTITY QUANTITY
, MOL.QUANTITY_DELIVERED QUANTITY_DELIVERED
, MOL.QUANTITY_DETAILED QUANTITY_DETAILED
, MOL.DATE_REQUIRED DATE_REQUIRED
, MOL.REASON_ID REASON_ID
, MOL.REFERENCE REFERENCE
, MOL.REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE
, MOL.REFERENCE_ID REFERENCE_ID
, MOL.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, MOL.LINE_STATUS LINE_STATUS
, MOL.STATUS_DATE STATUS_DATE
, MOL.LAST_UPDATED_BY LAST_UPDATED_BY
, MOL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MOL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MOL.CREATED_BY CREATED_BY
, MOL.CREATION_DATE CREATION_DATE
, MOL.REQUEST_ID REQUEST_ID
, MOL.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, MOL.PROGRAM_ID PROGRAM_ID
, MOL.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MOL.ATTRIBUTE1 ATTRIBUTE1
, MOL.ATTRIBUTE2 ATTRIBUTE2
, MOL.ATTRIBUTE3 ATTRIBUTE3
, MOL.ATTRIBUTE4 ATTRIBUTE4
, MOL.ATTRIBUTE5 ATTRIBUTE5
, MOL.ATTRIBUTE6 ATTRIBUTE6
, MOL.ATTRIBUTE7 ATTRIBUTE7
, MOL.ATTRIBUTE8 ATTRIBUTE8
, MOL.ATTRIBUTE9 ATTRIBUTE9
, MOL.ATTRIBUTE10 ATTRIBUTE10
, MOL.ATTRIBUTE11 ATTRIBUTE11
, MOL.ATTRIBUTE12 ATTRIBUTE12
, MOL.ATTRIBUTE13 ATTRIBUTE13
, MOL.ATTRIBUTE14 ATTRIBUTE14
, MOL.ATTRIBUTE15 ATTRIBUTE15
, MOL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, MOL.TXN_SOURCE_ID TXN_SOURCE_ID
, MOL.TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID
, MOL.TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID
, MOL.PRIMARY_QUANTITY PRIMARY_QUANTITY
, MOL.TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, MOL.PICK_STRATEGY_ID PICK_STRATEGY_ID
, MOL.PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID
, MOL.UNIT_NUMBER UNIT_NUMBER
, MOL.QC_GRADE QC_GRADE
, MOL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, MOL.SECONDARY_QUANTITY SECONDARY_QUANTITY
, MOL.SECONDARY_QUANTITY_DELIVERED SECONDARY_QUANTITY_DELIVERED
, MOL.SECONDARY_QUANTITY_DETAILED SECONDARY_QUANTITY_DETAILED
, ITM.ALLOC_CLASS ALLOC_CLASS
, MTI.SEGMENT1 ITEM_NO
, ITM.ITEM_DESC1 ITEM_DESCRIPTION
, ITM.LOT_CTL LOT_CTL
, ITM.LOCT_CTL LOCT_CTL
, MOL.SHIP_SET_ID
FROM IC_TXN_REQUEST_LINES MOL
, IC_TXN_REQUEST_HEADERS MOH
, MTL_TRANSACTION_TYPES MTT
, MFG_LOOKUPS MFG
, MTL_SYSTEM_ITEMS MTI
, IC_ITEM_MST ITM
WHERE ITM.ITEM_NO = MTI.SEGMENT1
AND MTI.ORGANIZATION_ID = MOL.ORGANIZATION_ID
AND MTI.INVENTORY_ITEM_ID = MOL.INVENTORY_ITEM_ID
AND MTT.TRANSACTION_TYPE_ID(+) = MOL.TRANSACTION_TYPE_ID
AND MFG.LOOKUP_TYPE(+) = 'MOVE_ORDER_TYPE'
AND MFG.LOOKUP_CODE(+) = MOH.MOVE_ORDER_TYPE
AND MOL.HEADER_ID = MOH.HEADER_ID