INV_TRANSACTION_LOTS_TEMP_V

Details

• Schema: FUSION

• Object owner: INV

• Object type: VIEW

Columns

Name

ORGANIZATION_ID INVENTORY_ITEM_ID TRANSACTION_TEMP_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID TRANSACTION_QUANTITY PRIMARY_QUANTITY LOT_NUMBER LOT_EXPIRATION_DATE ERROR_CODE SERIAL_TRANSACTION_TEMP_ID GROUP_HEADER_ID PUT_AWAY_RULE_ID PICK_RULE_ID DESCRIPTION VENDOR_NAME SUPPLIER_LOT_NUMBER ORIGINATION_DATE DATE_CODE GRADE_CODE CHANGE_DATE MATURITY_DATE STATUS_ID RETEST_DATE AGE ITEM_SIZE COLOR LOT_VOLUME VOLUME_UOM PLACE_OF_ORIGIN BEST_BY_DATE LOT_LENGTH LENGTH_UOM RECYCLED_CONTENT LOT_THICKNESS THICKNESS_UOM LOT_WIDTH WIDTH_UOM CURL_WRINKLE_FOLD LOT_ATTRIBUTE_CATEGORY C_ATTRIBUTE1 C_ATTRIBUTE2 C_ATTRIBUTE3 C_ATTRIBUTE4 C_ATTRIBUTE5 C_ATTRIBUTE6 C_ATTRIBUTE7 C_ATTRIBUTE8 C_ATTRIBUTE9 C_ATTRIBUTE10 C_ATTRIBUTE11 C_ATTRIBUTE12 C_ATTRIBUTE13 C_ATTRIBUTE14 C_ATTRIBUTE15 C_ATTRIBUTE16 C_ATTRIBUTE17 C_ATTRIBUTE18 C_ATTRIBUTE19 C_ATTRIBUTE20 D_ATTRIBUTE1 D_ATTRIBUTE2 D_ATTRIBUTE3 D_ATTRIBUTE4 D_ATTRIBUTE5 D_ATTRIBUTE6 D_ATTRIBUTE7 D_ATTRIBUTE8 D_ATTRIBUTE9 D_ATTRIBUTE10 N_ATTRIBUTE1 N_ATTRIBUTE2 N_ATTRIBUTE3 N_ATTRIBUTE4 N_ATTRIBUTE5 N_ATTRIBUTE6 N_ATTRIBUTE7 N_ATTRIBUTE8 N_ATTRIBUTE9 N_ATTRIBUTE10 VENDOR_ID TERRITORY_CODE

Query

SQL_Statement

SELECT DECODE(IMTT.TRANSACTION_ACTION_ID, 3, IMTT.TRANSFER_ORGANIZATION, IMTT.ORGANIZATION_ID) ORGANIZATION_ID , IMTT.INVENTORY_ITEM_ID , ITLT.TRANSACTION_TEMP_ID , ITLT.LAST_UPDATE_DATE , ITLT.LAST_UPDATED_BY , ITLT.CREATION_DATE , ITLT.CREATED_BY , ITLT.LAST_UPDATE_LOGIN , ITLT.REQUEST_ID , ITLT.TRANSACTION_QUANTITY , ITLT.PRIMARY_QUANTITY , ITLT.LOT_NUMBER , ITLT.LOT_EXPIRATION_DATE , ITLT.ERROR_CODE , ITLT.SERIAL_TRANSACTION_TEMP_ID , ITLT.GROUP_HEADER_ID , ITLT.PUT_AWAY_RULE_ID , ITLT.PICK_RULE_ID , ITLT.DESCRIPTION , ITLT.VENDOR_NAME , ITLT.SUPPLIER_LOT_NUMBER , ITLT.ORIGINATION_DATE , ITLT.DATE_CODE , ITLT.GRADE_CODE , ITLT.CHANGE_DATE , ITLT.MATURITY_DATE , ITLT.STATUS_ID , ITLT.RETEST_DATE , ITLT.AGE , ITLT.ITEM_SIZE , ITLT.COLOR , ITLT.LOT_VOLUME , ITLT.VOLUME_UOM , ITLT.PLACE_OF_ORIGIN , ITLT.BEST_BY_DATE , ITLT.LOT_LENGTH , ITLT.LENGTH_UOM , ITLT.RECYCLED_CONTENT , ITLT.LOT_THICKNESS , ITLT.THICKNESS_UOM , ITLT.LOT_WIDTH , ITLT.WIDTH_UOM , ITLT.CURL_WRINKLE_FOLD , ITLT.LOT_ATTRIBUTE_CATEGORY , ITLT.C_ATTRIBUTE1 , ITLT.C_ATTRIBUTE2 , ITLT.C_ATTRIBUTE3 , ITLT.C_ATTRIBUTE4 , ITLT.C_ATTRIBUTE5 , ITLT.C_ATTRIBUTE6 , ITLT.C_ATTRIBUTE7 , ITLT.C_ATTRIBUTE8 , ITLT.C_ATTRIBUTE9 , ITLT.C_ATTRIBUTE10 , ITLT.C_ATTRIBUTE11 , ITLT.C_ATTRIBUTE12 , ITLT.C_ATTRIBUTE13 , ITLT.C_ATTRIBUTE14 , ITLT.C_ATTRIBUTE15 , ITLT.C_ATTRIBUTE16 , ITLT.C_ATTRIBUTE17 , ITLT.C_ATTRIBUTE18 , ITLT.C_ATTRIBUTE19 , ITLT.C_ATTRIBUTE20 , ITLT.D_ATTRIBUTE1 , ITLT.D_ATTRIBUTE2 , ITLT.D_ATTRIBUTE3 , ITLT.D_ATTRIBUTE4 , ITLT.D_ATTRIBUTE5 , ITLT.D_ATTRIBUTE6 , ITLT.D_ATTRIBUTE7 , ITLT.D_ATTRIBUTE8 , ITLT.D_ATTRIBUTE9 , ITLT.D_ATTRIBUTE10 , ITLT.N_ATTRIBUTE1 , ITLT.N_ATTRIBUTE2 , ITLT.N_ATTRIBUTE3 , ITLT.N_ATTRIBUTE4 , ITLT.N_ATTRIBUTE5 , ITLT.N_ATTRIBUTE6 , ITLT.N_ATTRIBUTE7 , ITLT.N_ATTRIBUTE8 , ITLT.N_ATTRIBUTE9 , ITLT.N_ATTRIBUTE10 , ITLT.VENDOR_ID , ITLT.TERRITORY_CODE FROM INV_TRANSACTION_LOTS_TEMP ITLT , INV_MATERIAL_TXNS_TEMP IMTT WHERE ITLT.TRANSACTION_TEMP_ID = IMTT.TRANSACTION_TEMP_ID