VIEW: APPS.IC_TXN_REQUEST_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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