INV_TXN_REQUEST_LINES

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
LINE_ID REQUEST_NUMBER MOVE_ORDER_TYPE MOVE_ORDER_TYPE_NAME DESCRIPTION HEADER_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_TYPE_ID TRANSACTION_TYPE_NAME TRANSACTION_ACTION_ID LINE_NUMBER ORGANIZATION_ID INVENTORY_ITEM_ID REVISION FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_CODE FROM_SUB_LOCATOR_TYPE FROM_SUB_ASSET FROM_SUB_QUANTITY_TRACKED FROM_LOCATOR_ID TO_SUBINVENTORY_CODE TO_SUB_LOCATOR_TYPE TO_SUB_ASSET TO_SUB_QUANTITY_TRACKED TO_SUBINVENTORY_ID TO_LOCATOR_ID TO_ACCOUNT_ID SHIP_TO_LOCATION_ID LOT_NUMBER SERIAL_NUMBER_START SERIAL_NUMBER_END UOM_CODE QUANTITY REQUIRED_QUANTITY QUANTITY_DELIVERED QUANTITY_DETAILED DATE_REQUIRED REASON_ID REFERENCE_NAME REFERENCE_TYPE_CODE REFERENCE_ID PROJECT_ID TASK_ID TRANSACTION_HEADER_ID LINE_STATUS STATUS_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE CREATED_BY CREATION_DATE REQUEST_ID ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_CATEGORY TXN_SOURCE_ID TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_DETAIL_ID PRIMARY_QUANTITY TO_ORGANIZATION_ID PICK_STRATEGY_ID PUT_AWAY_STRATEGY_ID UNIT_NUMBER FROM_COST_GROUP_ID FROM_COST_GROUP_NAME TO_COST_GROUP_ID TO_COST_GROUP_NAME LPN_ID TO_LPN_ID REFERENCE_DETAIL_ID ASSIGNMENT_ID LPN_NUMBER TO_LPN_NUMBER GRADE_CODE SECONDARY_QUANTITY SECONDARY_QUANTITY_DETAILED SECONDARY_QUANTITY_DELIVERED SECONDARY_REQUIRED_QUANTITY SECONDARY_UOM_CODE LOCATION_REQUIRED_FLAG

Name

LINE_ID

REQUEST_NUMBER

MOVE_ORDER_TYPE

MOVE_ORDER_TYPE_NAME

DESCRIPTION

HEADER_ID

TRANSACTION_SOURCE_TYPE_ID

TRANSACTION_TYPE_ID

TRANSACTION_TYPE_NAME

TRANSACTION_ACTION_ID

LINE_NUMBER

ORGANIZATION_ID

INVENTORY_ITEM_ID

REVISION

FROM_SUBINVENTORY_ID

FROM_SUBINVENTORY_CODE

FROM_SUB_LOCATOR_TYPE

FROM_SUB_ASSET

FROM_SUB_QUANTITY_TRACKED

FROM_LOCATOR_ID

TO_SUBINVENTORY_CODE

TO_SUB_LOCATOR_TYPE

TO_SUB_ASSET

TO_SUB_QUANTITY_TRACKED

TO_SUBINVENTORY_ID

TO_LOCATOR_ID

TO_ACCOUNT_ID

SHIP_TO_LOCATION_ID

LOT_NUMBER

SERIAL_NUMBER_START

SERIAL_NUMBER_END

UOM_CODE

QUANTITY

REQUIRED_QUANTITY

QUANTITY_DELIVERED

QUANTITY_DETAILED

DATE_REQUIRED

REASON_ID

REFERENCE_NAME

REFERENCE_TYPE_CODE

REFERENCE_ID

PROJECT_ID

TASK_ID

TRANSACTION_HEADER_ID

LINE_STATUS

STATUS_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

REQUEST_ID

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

TXN_SOURCE_ID

TXN_SOURCE_LINE_ID

TXN_SOURCE_LINE_DETAIL_ID

PRIMARY_QUANTITY

TO_ORGANIZATION_ID

PICK_STRATEGY_ID

PUT_AWAY_STRATEGY_ID

UNIT_NUMBER

FROM_COST_GROUP_ID

FROM_COST_GROUP_NAME

TO_COST_GROUP_ID

TO_COST_GROUP_NAME

LPN_ID

TO_LPN_ID

REFERENCE_DETAIL_ID

ASSIGNMENT_ID

LPN_NUMBER

TO_LPN_NUMBER

GRADE_CODE

SECONDARY_QUANTITY

SECONDARY_QUANTITY_DETAILED

SECONDARY_QUANTITY_DELIVERED

SECONDARY_REQUIRED_QUANTITY

SECONDARY_UOM_CODE

LOCATION_REQUIRED_FLAG

Query

SQL_Statement
SELECT MTRL.LINE_ID LINE_ID, MTRH.REQUEST_NUMBER REQUEST_NUMBER, MTRH.MOVE_ORDER_TYPE MOVE_ORDER_TYPE, MFG2.MEANING MOVE_ORDER_TYPE_NAME, MTRH.DESCRIPTION DESCRIPTION, MTRL.HEADER_ID HEADER_ID, MTT.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, MTRL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME, MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, MTRL.LINE_NUMBER LINE_NUMBER, MTRL.ORGANIZATION_ID ORGANIZATION_ID, MTRL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, MTRL.REVISION REVISION, MTRL.FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID, MTRL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE, MSS.LOCATOR_TYPE FROM_SUB_LOCATOR_TYPE, MSS.ASSET_INVENTORY FROM_SUB_ASSET, MSS.QUANTITY_TRACKED FROM_SUB_QUANTITY_TRACKED, MTRL.FROM_LOCATOR_ID FROM_LOCATOR_ID, MTRL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE, MSS1.LOCATOR_TYPE TO_SUB_LOCATOR_TYPE, MSS1.ASSET_INVENTORY TO_SUB_ASSET, MSS1.QUANTITY_TRACKED TO_SUB_QUANTITY_TRACKED, MTRL.TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID, MTRL.TO_LOCATOR_ID TO_LOCATOR_ID, MTRL.TO_ACCOUNT_ID TO_ACCOUNT_ID , MTRL.ship_TO_location_id ship_to_location_id , MTRL.LOT_NUMBER LOT_NUMBER, MTRL.SERIAL_NUMBER_START SERIAL_NUMBER_START, MTRL.SERIAL_NUMBER_END SERIAL_NUMBER_END, MTRL.UOM_CODE UOM_CODE, MTRL.QUANTITY QUANTITY, MTRL.REQUIRED_QUANTITY REQUIRED_QUANTITY, MTRL.QUANTITY_DELIVERED QUANTITY_DELIVERED, MTRL.QUANTITY_DETAILED QUANTITY_DETAILED, MTRL.DATE_REQUIRED DATE_REQUIRED, MTRL.REASON_ID REASON_ID, MTRL.REFERENCE_NAME REFERENCE_NAME, MTRL.REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE, MTRL.REFERENCE_ID REFERENCE_ID, MTRL.PJC_PROJECT_ID PROJECT_ID, MTRL.PJC_TASK_ID TASK_ID, MTRL.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID, MTRL.LINE_STATUS LINE_STATUS, MTRL.STATUS_DATE STATUS_DATE, MTRL.LAST_UPDATED_BY LAST_UPDATED_BY, MTRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MTRL.LAST_UPDATE_DATE LAST_UPDATE_DATE, MTRL.CREATED_BY CREATED_BY, MTRL.CREATION_DATE CREATION_DATE, MTRL.REQUEST_ID REQUEST_ID, MTRL.ATTRIBUTE1 ATTRIBUTE1, MTRL.ATTRIBUTE2 ATTRIBUTE2, MTRL.ATTRIBUTE3 ATTRIBUTE3, MTRL.ATTRIBUTE4 ATTRIBUTE4, MTRL.ATTRIBUTE5 ATTRIBUTE5, MTRL.ATTRIBUTE6 ATTRIBUTE6, MTRL.ATTRIBUTE7 ATTRIBUTE7, MTRL.ATTRIBUTE8 ATTRIBUTE8, MTRL.ATTRIBUTE9 ATTRIBUTE9, MTRL.ATTRIBUTE10 ATTRIBUTE10, MTRL.ATTRIBUTE11 ATTRIBUTE11, MTRL.ATTRIBUTE12 ATTRIBUTE12, MTRL.ATTRIBUTE13 ATTRIBUTE13, MTRL.ATTRIBUTE14 ATTRIBUTE14, MTRL.ATTRIBUTE15 ATTRIBUTE15, MTRL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, MTRL.TXN_SOURCE_ID TXN_SOURCE_ID, MTRL.TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID, MTRL.TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID, MTRL.PRIMARY_QUANTITY PRIMARY_QUANTITY, MTRL.TO_ORGANIZATION_ID TO_ORGANIZATION_ID, MTRL.PICK_STRATEGY_ID PICK_STRATEGY_ID, MTRL.PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID, MTRL.UNIT_NUMBER UNIT_NUMBER, MTRL.FROM_COST_GROUP_ID FROM_COST_GROUP_ID, '' FROM_COST_GROUP_NAME, MTRL.TO_COST_GROUP_ID TO_COST_GROUP_ID, '' TO_COST_GROUP_NAME, MTRL.LPN_ID LPN_ID, MTRL.TO_LPN_ID TO_LPN_ID, MTRL.REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID, MTRL.ASSIGNMENT_ID ASSIGNMENT_ID, '' LPN_NUMBER, '' TO_LPN_NUMBER, MTRL.GRADE_CODE, MTRL.SECONDARY_QUANTITY, MTRL.SECONDARY_QUANTITY_DETAILED, MTRL.SECONDARY_QUANTITY_DELIVERED, MTRL.SECONDARY_REQUIRED_QUANTITY, MTRL.SECONDARY_UOM_CODE, MTT.LOCATION_REQUIRED_FLAG FROM INV_TXN_REQUEST_LINES MTRL, INV_TXN_REQUEST_HEADERS MTRH, INV_TRANSACTION_TYPES_VL MTT, INV_SECONDARY_INVENTORIES MSS, INV_SECONDARY_INVENTORIES MSS1, FND_LOOKUPS MFG, FND_LOOKUPS MFG2 WHERE MTRH.HEADER_ID = MTRL.HEADER_ID AND MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID AND MSS.SECONDARY_INVENTORY_NAME(+) = MTRL.FROM_SUBINVENTORY_CODE AND MSS.ORGANIZATION_ID(+) = MTRL.ORGANIZATION_ID AND MSS1.SECONDARY_INVENTORY_NAME(+) = MTRL.TO_SUBINVENTORY_CODE AND MSS1.ORGANIZATION_ID(+) = MTRL.ORGANIZATION_ID AND MFG.LOOKUP_TYPE = 'INV_TXN_REQUEST_STATUS' AND MFG.LOOKUP_CODE = TO_CHAR(MTRL.LINE_STATUS) AND MFG2.LOOKUP_TYPE = 'INV_MOVE_ORDER_TYPE' AND MFG2.LOOKUP_CODE = TO_CHAR(MTRH.MOVE_ORDER_TYPE)

SQL_Statement

SELECT MTRL.LINE_ID LINE_ID,

MTRH.REQUEST_NUMBER REQUEST_NUMBER,

MTRH.MOVE_ORDER_TYPE MOVE_ORDER_TYPE,

MFG2.MEANING MOVE_ORDER_TYPE_NAME,

MTRH.DESCRIPTION DESCRIPTION,

MTRL.HEADER_ID HEADER_ID,

MTT.TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID,

MTRL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID,

MTT.TRANSACTION_TYPE_NAME TRANSACTION_TYPE_NAME,

MTT.TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID,

MTRL.LINE_NUMBER LINE_NUMBER,

MTRL.ORGANIZATION_ID ORGANIZATION_ID,

MTRL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

MTRL.REVISION REVISION,

MTRL.FROM_SUBINVENTORY_ID FROM_SUBINVENTORY_ID,

MTRL.FROM_SUBINVENTORY_CODE FROM_SUBINVENTORY_CODE,

MSS.LOCATOR_TYPE FROM_SUB_LOCATOR_TYPE,

MSS.ASSET_INVENTORY FROM_SUB_ASSET,

MSS.QUANTITY_TRACKED FROM_SUB_QUANTITY_TRACKED,

MTRL.FROM_LOCATOR_ID FROM_LOCATOR_ID,

MTRL.TO_SUBINVENTORY_CODE TO_SUBINVENTORY_CODE,

MSS1.LOCATOR_TYPE TO_SUB_LOCATOR_TYPE,

MSS1.ASSET_INVENTORY TO_SUB_ASSET,

MSS1.QUANTITY_TRACKED TO_SUB_QUANTITY_TRACKED,

MTRL.TO_SUBINVENTORY_ID TO_SUBINVENTORY_ID,

MTRL.TO_LOCATOR_ID TO_LOCATOR_ID,

MTRL.TO_ACCOUNT_ID TO_ACCOUNT_ID ,

MTRL.ship_TO_location_id ship_to_location_id ,

MTRL.LOT_NUMBER LOT_NUMBER,

MTRL.SERIAL_NUMBER_START SERIAL_NUMBER_START,

MTRL.SERIAL_NUMBER_END SERIAL_NUMBER_END,

MTRL.UOM_CODE UOM_CODE, MTRL.QUANTITY QUANTITY,

MTRL.REQUIRED_QUANTITY REQUIRED_QUANTITY,

MTRL.QUANTITY_DELIVERED QUANTITY_DELIVERED,

MTRL.QUANTITY_DETAILED QUANTITY_DETAILED,

MTRL.DATE_REQUIRED DATE_REQUIRED,

MTRL.REASON_ID REASON_ID,

MTRL.REFERENCE_NAME REFERENCE_NAME,

MTRL.REFERENCE_TYPE_CODE REFERENCE_TYPE_CODE,

MTRL.REFERENCE_ID REFERENCE_ID,

MTRL.PJC_PROJECT_ID PROJECT_ID,

MTRL.PJC_TASK_ID TASK_ID,

MTRL.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID,

MTRL.LINE_STATUS LINE_STATUS,

MTRL.STATUS_DATE STATUS_DATE,

MTRL.LAST_UPDATED_BY LAST_UPDATED_BY,

MTRL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MTRL.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MTRL.CREATED_BY CREATED_BY,

MTRL.CREATION_DATE CREATION_DATE,

MTRL.REQUEST_ID REQUEST_ID,

MTRL.ATTRIBUTE1 ATTRIBUTE1,

MTRL.ATTRIBUTE2 ATTRIBUTE2,

MTRL.ATTRIBUTE3 ATTRIBUTE3,

MTRL.ATTRIBUTE4 ATTRIBUTE4,

MTRL.ATTRIBUTE5 ATTRIBUTE5,

MTRL.ATTRIBUTE6 ATTRIBUTE6,

MTRL.ATTRIBUTE7 ATTRIBUTE7,

MTRL.ATTRIBUTE8 ATTRIBUTE8,

MTRL.ATTRIBUTE9 ATTRIBUTE9,

MTRL.ATTRIBUTE10 ATTRIBUTE10,

MTRL.ATTRIBUTE11 ATTRIBUTE11,

MTRL.ATTRIBUTE12 ATTRIBUTE12,

MTRL.ATTRIBUTE13 ATTRIBUTE13,

MTRL.ATTRIBUTE14 ATTRIBUTE14,

MTRL.ATTRIBUTE15 ATTRIBUTE15,

MTRL.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

MTRL.TXN_SOURCE_ID TXN_SOURCE_ID,

MTRL.TXN_SOURCE_LINE_ID TXN_SOURCE_LINE_ID,

MTRL.TXN_SOURCE_LINE_DETAIL_ID TXN_SOURCE_LINE_DETAIL_ID,

MTRL.PRIMARY_QUANTITY PRIMARY_QUANTITY,

MTRL.TO_ORGANIZATION_ID TO_ORGANIZATION_ID,

MTRL.PICK_STRATEGY_ID PICK_STRATEGY_ID,

MTRL.PUT_AWAY_STRATEGY_ID PUT_AWAY_STRATEGY_ID,

MTRL.UNIT_NUMBER UNIT_NUMBER,

MTRL.FROM_COST_GROUP_ID FROM_COST_GROUP_ID,

'' FROM_COST_GROUP_NAME,

MTRL.TO_COST_GROUP_ID TO_COST_GROUP_ID,

'' TO_COST_GROUP_NAME,

MTRL.LPN_ID LPN_ID,

MTRL.TO_LPN_ID TO_LPN_ID,

MTRL.REFERENCE_DETAIL_ID REFERENCE_DETAIL_ID,

MTRL.ASSIGNMENT_ID ASSIGNMENT_ID,

'' LPN_NUMBER,

'' TO_LPN_NUMBER,

MTRL.GRADE_CODE,

MTRL.SECONDARY_QUANTITY,

MTRL.SECONDARY_QUANTITY_DETAILED,

MTRL.SECONDARY_QUANTITY_DELIVERED,

MTRL.SECONDARY_REQUIRED_QUANTITY,

MTRL.SECONDARY_UOM_CODE,

MTT.LOCATION_REQUIRED_FLAG

FROM INV_TXN_REQUEST_LINES MTRL,

INV_TXN_REQUEST_HEADERS MTRH,

INV_TRANSACTION_TYPES_VL MTT,

INV_SECONDARY_INVENTORIES MSS,

INV_SECONDARY_INVENTORIES MSS1,

FND_LOOKUPS MFG, FND_LOOKUPS MFG2

WHERE MTRH.HEADER_ID = MTRL.HEADER_ID

AND MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID

AND MSS.SECONDARY_INVENTORY_NAME(+) = MTRL.FROM_SUBINVENTORY_CODE

AND MSS.ORGANIZATION_ID(+) = MTRL.ORGANIZATION_ID

AND MSS1.SECONDARY_INVENTORY_NAME(+) = MTRL.TO_SUBINVENTORY_CODE

AND MSS1.ORGANIZATION_ID(+) = MTRL.ORGANIZATION_ID

AND MFG.LOOKUP_TYPE = 'INV_TXN_REQUEST_STATUS'

AND MFG.LOOKUP_CODE = TO_CHAR(MTRL.LINE_STATUS)

AND MFG2.LOOKUP_TYPE = 'INV_MOVE_ORDER_TYPE'

AND MFG2.LOOKUP_CODE = TO_CHAR(MTRH.MOVE_ORDER_TYPE)