INV_STRATEGY_MAT_TXN_TMP

Details

Schema: FUSION
Object owner: INV
Object type: VIEW

Columns

Name
TYPE_CODE LINE_ID HEADER_ID LINE_NUMBER INVENTORY_ITEM_ID REVISION FROM_ORGANIZATION_ID FROM_SUBINVENTORY_CODE FROM_LOCATOR_ID TO_ORGANIZATION_ID TO_SUBINVENTORY_CODE TO_LOCATOR_ID TO_ACCOUNT_ID LOT_NUMBER TRANSACTION_UOM TRANSACTION_QUANTITY DATE_REQUIRED REASON_ID REFERENCE_NAME REFERENCE_TYPE_CODE REFERENCE_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 PRIMARY_QUANTITY TRANSACTION_TYPE_ID TRANSACTION_SOURCE_TYPE_ID TRANSACTION_ACTION_ID TXN_SOURCE_ID TXN_SOURCE_LINE_ID TXN_SOURCE_NAME TXN_SOURCE_LINE_DETAIL FREIGHT_CARRIER_CODE CUSTOMER_ID

Name

TYPE_CODE

LINE_ID

HEADER_ID

LINE_NUMBER

INVENTORY_ITEM_ID

REVISION

FROM_ORGANIZATION_ID

FROM_SUBINVENTORY_CODE

FROM_LOCATOR_ID

TO_ORGANIZATION_ID

TO_SUBINVENTORY_CODE

TO_LOCATOR_ID

TO_ACCOUNT_ID

LOT_NUMBER

TRANSACTION_UOM

TRANSACTION_QUANTITY

DATE_REQUIRED

REASON_ID

REFERENCE_NAME

REFERENCE_TYPE_CODE

REFERENCE_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

PRIMARY_QUANTITY

TRANSACTION_TYPE_ID

TRANSACTION_SOURCE_TYPE_ID

TRANSACTION_ACTION_ID

TXN_SOURCE_ID

TXN_SOURCE_LINE_ID

TXN_SOURCE_NAME

TXN_SOURCE_LINE_DETAIL

FREIGHT_CARRIER_CODE

CUSTOMER_ID

Query

SQL_Statement
SELECT 2 as TYPE_CODE, mtrl.LINE_ID ,mtrl.HEADER_ID ,mtrl.LINE_NUMBER ,mtrl.INVENTORY_ITEM_ID ,mtrl.REVISION ,mtrl.ORGANIZATION_ID FROM_ORGANIZATION_ID ,mtrl.FROM_SUBINVENTORY_CODE ,mtrl.FROM_LOCATOR_ID ,DECODE(mtt.TRANSACTION_ACTION_ID,3,TO_ORGANIZATION_ID,ORGANIZATION_ID) TO_ORGANIZATION_ID,mtrl.TO_SUBINVENTORY_CODE ,mtrl.TO_LOCATOR_ID ,mtrl.TO_ACCOUNT_ID ,mtrl.LOT_NUMBER ,mtrl.UOM_CODE TRANSACTION_UOM,mtrl.QUANTITY-NVL(mtrl.QUANTITY_DETAILED,0) TRANSACTION_QUANTITY ,mtrl.DATE_REQUIRED ,mtrl.REASON_ID ,mtrl.REFERENCE_NAME ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_ID ,mtrl.TRANSACTION_HEADER_ID ,mtrl.LINE_STATUS ,mtrl.STATUS_DATE ,mtrl.LAST_UPDATED_BY ,mtrl.LAST_UPDATE_LOGIN ,mtrl.LAST_UPDATE_DATE ,mtrl.CREATED_BY ,mtrl.CREATION_DATE ,mtrl.REQUEST_ID ,mtrl.ATTRIBUTE1 ,mtrl.ATTRIBUTE2 ,mtrl.ATTRIBUTE3 ,mtrl.ATTRIBUTE4 ,mtrl.ATTRIBUTE5 ,mtrl.ATTRIBUTE6 ,mtrl.ATTRIBUTE7 ,mtrl.ATTRIBUTE8 ,mtrl.ATTRIBUTE9 ,mtrl.ATTRIBUTE10 ,mtrl.ATTRIBUTE11 ,mtrl.ATTRIBUTE12 ,mtrl.ATTRIBUTE13 ,mtrl.ATTRIBUTE14 ,mtrl.ATTRIBUTE15 ,mtrl.ATTRIBUTE_CATEGORY ,mtrl.PRIMARY_QUANTITY ,mtrl.TRANSACTION_TYPE_ID ,mtrl.TRANSACTION_SOURCE_TYPE_ID ,mtt.TRANSACTION_ACTION_ID ,wtct.TXN_SOURCE_ID ,wtct.TXN_SOURCE_LINE_ID ,wtct.TXN_SOURCE_NAME ,wtct.TXN_SOURCE_LINE_DETAIL ,wtct.FREIGHT_CARRIER_CODE ,wtct.CUSTOMER_ID FROM INV_TXN_REQUEST_LINES mtrl ,INV_TRANSACTION_TYPES mtt ,INV_TXN_CONTEXT_GT wtct WHERE mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID in (1,2,3,21,28,34) AND mtrl.LINE_ID = wtct.LINE_ID UNION ALL SELECT 1 as TYPE_CODE ,mtrl.LINE_ID ,mtrl.HEADER_ID ,mtrl.LINE_NUMBER ,mtrl.INVENTORY_ITEM_ID ,mtrl.REVISION ,decode(mtt.transaction_action_id,3,mtrl.to_organization_id, mtrl.organization_id) FROM_ORGANIZATION_ID ,mtrl.FROM_SUBINVENTORY_CODE ,mtrl.FROM_LOCATOR_ID ,mtrl.organization_id TO_ORGANIZATION_ID,mtrl.TO_SUBINVENTORY_CODE ,mtrl.TO_LOCATOR_ID ,mtrl.TO_ACCOUNT_ID ,mtrl.LOT_NUMBER ,mtrl.UOM_CODE TRANSACTION_UOM ,mtrl.QUANTITY-NVL(mtrl.QUANTITY_DETAILED,0) TRANSACTION_QUANTITY ,mtrl.DATE_REQUIRED ,mtrl.REASON_ID ,mtrl.REFERENCE_NAME ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_ID ,mtrl.TRANSACTION_HEADER_ID ,mtrl.LINE_STATUS ,mtrl.STATUS_DATE ,mtrl.LAST_UPDATED_BY ,mtrl.LAST_UPDATE_LOGIN ,mtrl.LAST_UPDATE_DATE ,mtrl.CREATED_BY ,mtrl.CREATION_DATE ,mtrl.REQUEST_ID ,mtrl.ATTRIBUTE1 ,mtrl.ATTRIBUTE2 ,mtrl.ATTRIBUTE3 ,mtrl.ATTRIBUTE4 ,mtrl.ATTRIBUTE5 ,mtrl.ATTRIBUTE6 ,mtrl.ATTRIBUTE7 ,mtrl.ATTRIBUTE8 ,mtrl.ATTRIBUTE9 ,mtrl.ATTRIBUTE10 ,mtrl.ATTRIBUTE11 ,mtrl.ATTRIBUTE12 ,mtrl.ATTRIBUTE13 ,mtrl.ATTRIBUTE14 ,mtrl.ATTRIBUTE15 ,mtrl.ATTRIBUTE_CATEGORY ,mtrl.PRIMARY_QUANTITY ,mtrl.TRANSACTION_TYPE_ID ,mtrl.TRANSACTION_SOURCE_TYPE_ID ,mtt.TRANSACTION_ACTION_ID ,wtct.TXN_SOURCE_ID ,wtct.TXN_SOURCE_LINE_ID ,wtct.TXN_SOURCE_NAME ,wtct.TXN_SOURCE_LINE_DETAIL ,wtct.FREIGHT_CARRIER_CODE ,wtct.CUSTOMER_ID FROM INV_TXN_REQUEST_LINES mtrl ,INV_TRANSACTION_TYPES mtt ,INV_TXN_CONTEXT_GT wtct WHERE mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID in (2,3,12,27,28,31,33) AND mtrl.LINE_ID = wtct.LINE_ID

SQL_Statement

SELECT 2 as TYPE_CODE, mtrl.LINE_ID ,mtrl.HEADER_ID ,mtrl.LINE_NUMBER ,mtrl.INVENTORY_ITEM_ID ,mtrl.REVISION ,mtrl.ORGANIZATION_ID FROM_ORGANIZATION_ID ,mtrl.FROM_SUBINVENTORY_CODE ,mtrl.FROM_LOCATOR_ID ,DECODE(mtt.TRANSACTION_ACTION_ID,3,TO_ORGANIZATION_ID,ORGANIZATION_ID) TO_ORGANIZATION_ID,mtrl.TO_SUBINVENTORY_CODE ,mtrl.TO_LOCATOR_ID ,mtrl.TO_ACCOUNT_ID ,mtrl.LOT_NUMBER ,mtrl.UOM_CODE TRANSACTION_UOM,mtrl.QUANTITY-NVL(mtrl.QUANTITY_DETAILED,0) TRANSACTION_QUANTITY ,mtrl.DATE_REQUIRED ,mtrl.REASON_ID ,mtrl.REFERENCE_NAME ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_ID ,mtrl.TRANSACTION_HEADER_ID ,mtrl.LINE_STATUS ,mtrl.STATUS_DATE ,mtrl.LAST_UPDATED_BY ,mtrl.LAST_UPDATE_LOGIN ,mtrl.LAST_UPDATE_DATE ,mtrl.CREATED_BY ,mtrl.CREATION_DATE ,mtrl.REQUEST_ID ,mtrl.ATTRIBUTE1 ,mtrl.ATTRIBUTE2 ,mtrl.ATTRIBUTE3 ,mtrl.ATTRIBUTE4 ,mtrl.ATTRIBUTE5 ,mtrl.ATTRIBUTE6 ,mtrl.ATTRIBUTE7 ,mtrl.ATTRIBUTE8 ,mtrl.ATTRIBUTE9 ,mtrl.ATTRIBUTE10 ,mtrl.ATTRIBUTE11 ,mtrl.ATTRIBUTE12 ,mtrl.ATTRIBUTE13 ,mtrl.ATTRIBUTE14 ,mtrl.ATTRIBUTE15 ,mtrl.ATTRIBUTE_CATEGORY ,mtrl.PRIMARY_QUANTITY ,mtrl.TRANSACTION_TYPE_ID ,mtrl.TRANSACTION_SOURCE_TYPE_ID ,mtt.TRANSACTION_ACTION_ID ,wtct.TXN_SOURCE_ID ,wtct.TXN_SOURCE_LINE_ID ,wtct.TXN_SOURCE_NAME ,wtct.TXN_SOURCE_LINE_DETAIL ,wtct.FREIGHT_CARRIER_CODE ,wtct.CUSTOMER_ID FROM INV_TXN_REQUEST_LINES mtrl ,INV_TRANSACTION_TYPES mtt ,INV_TXN_CONTEXT_GT wtct WHERE mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID in (1,2,3,21,28,34) AND mtrl.LINE_ID = wtct.LINE_ID UNION ALL SELECT 1 as TYPE_CODE ,mtrl.LINE_ID ,mtrl.HEADER_ID ,mtrl.LINE_NUMBER ,mtrl.INVENTORY_ITEM_ID ,mtrl.REVISION ,decode(mtt.transaction_action_id,3,mtrl.to_organization_id, mtrl.organization_id) FROM_ORGANIZATION_ID ,mtrl.FROM_SUBINVENTORY_CODE ,mtrl.FROM_LOCATOR_ID ,mtrl.organization_id TO_ORGANIZATION_ID,mtrl.TO_SUBINVENTORY_CODE ,mtrl.TO_LOCATOR_ID ,mtrl.TO_ACCOUNT_ID ,mtrl.LOT_NUMBER ,mtrl.UOM_CODE TRANSACTION_UOM ,mtrl.QUANTITY-NVL(mtrl.QUANTITY_DETAILED,0) TRANSACTION_QUANTITY ,mtrl.DATE_REQUIRED ,mtrl.REASON_ID ,mtrl.REFERENCE_NAME ,mtrl.REFERENCE_TYPE_CODE ,mtrl.REFERENCE_ID ,mtrl.TRANSACTION_HEADER_ID ,mtrl.LINE_STATUS ,mtrl.STATUS_DATE ,mtrl.LAST_UPDATED_BY ,mtrl.LAST_UPDATE_LOGIN ,mtrl.LAST_UPDATE_DATE ,mtrl.CREATED_BY ,mtrl.CREATION_DATE ,mtrl.REQUEST_ID ,mtrl.ATTRIBUTE1 ,mtrl.ATTRIBUTE2 ,mtrl.ATTRIBUTE3 ,mtrl.ATTRIBUTE4 ,mtrl.ATTRIBUTE5 ,mtrl.ATTRIBUTE6 ,mtrl.ATTRIBUTE7 ,mtrl.ATTRIBUTE8 ,mtrl.ATTRIBUTE9 ,mtrl.ATTRIBUTE10 ,mtrl.ATTRIBUTE11 ,mtrl.ATTRIBUTE12 ,mtrl.ATTRIBUTE13 ,mtrl.ATTRIBUTE14 ,mtrl.ATTRIBUTE15 ,mtrl.ATTRIBUTE_CATEGORY ,mtrl.PRIMARY_QUANTITY ,mtrl.TRANSACTION_TYPE_ID ,mtrl.TRANSACTION_SOURCE_TYPE_ID ,mtt.TRANSACTION_ACTION_ID ,wtct.TXN_SOURCE_ID ,wtct.TXN_SOURCE_LINE_ID ,wtct.TXN_SOURCE_NAME ,wtct.TXN_SOURCE_LINE_DETAIL ,wtct.FREIGHT_CARRIER_CODE ,wtct.CUSTOMER_ID FROM INV_TXN_REQUEST_LINES mtrl ,INV_TRANSACTION_TYPES mtt ,INV_TXN_CONTEXT_GT wtct WHERE mtrl.TRANSACTION_TYPE_ID = mtt.TRANSACTION_TYPE_ID AND mtt.TRANSACTION_ACTION_ID in (2,3,12,27,28,31,33) AND mtrl.LINE_ID = wtct.LINE_ID