VIEW: APPS.CS_EST_DETAILS_MTL_TXNS_V

Source

View Text - Preformatted

SELECT MTL.ROWID ROW_ID, MTL.DETAIL_TRANSACTION_ID , MTL.ESTIMATE_DETAIL_ID , MTL.LAST_UPDATE_DATE , MTL.LAST_UPDATED_BY , MTL.CREATION_DATE , MTL.CREATED_BY , MTL.LAST_UPDATE_LOGIN , MTL.ORGANIZATION_ID, ORG.ORGANIZATION_NAME, MTL.SERIAL_NUMBER , MTL.LOT_NUMBER , MTL.LOCATOR_ID , MTL.SUBINVENTORY_CODE, MTL.REVISION, MTL.TRANSACTION_TYPE_ID, MTL.INTERFACE_TO_INVENTORY_FLAG , MTL.Attribute1 , MTL.Attribute2 , MTL.Attribute3 , MTL.Attribute4 , MTL.Attribute5 , MTL.Attribute6 , MTL.Attribute7 , MTL.Attribute8 , MTL.Attribute9 , MTL.Attribute10 , MTL.Attribute11 , MTL.Attribute12 , MTL.Attribute13 , MTL.Attribute14 , MTL.Attribute15 , MTL.Context , ESTDTL.INVENTORY_ITEM_ID, ESTDTL.QUANTITY_REQUIRED QUANTITY, PAR.NEGATIVE_INV_RECEIPT_CODE, SEC.LOCATOR_TYPE SUB_LOCATION_CONTROL_CODE, PAR.STOCK_LOCATOR_CONTROL_CODE, MTT.TRANSACTION_ACTION_ID ACTION_ID, ESTDTL.UNIT_OF_MEASURE_CODE FROM CS_EST_DETAILS_MTL_TXNS MTL, CS_ESTIMATE_DETAILS ESTDTL, MTL_PARAMETERS PAR, MTL_SECONDARY_INVENTORIES SEC, MTL_TRANSACTION_TYPES MTT, HR_ORGANIZATION_INFORMATION HR, ORG_ORGANIZATION_DEFINITIONS ORG WHERE MTL.ESTIMATE_DETAIL_ID = ESTDTL.ESTIMATE_DETAIL_ID AND HR.ORG_INFORMATION1 = 'INV' AND HR.ORG_INFORMATION2 = 'Y' AND HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID AND MTT.Transaction_type_id = to_number( FND_PROFILE.VALUE_SPECIFIC('CS_FIELD_SERVICE_TRANSACTION_TYPE')) AND ORG.ORGANIZATION_ID = MTL.ORGANIZATION_ID AND PAR.ORGANIZATION_ID = MTL.ORGANIZATION_ID AND SEC.ORGANIZATION_ID = MTL.ORGANIZATION_ID AND SEC.SECONDARY_INVENTORY_NAME = NVL(MTL.SUBINVENTORY_CODE, FND_PROFILE.VALUE_SPECIFIC('CS_FIELD_SERVICE_SUBINVENTORY'))

View Text - HTML Formatted

SELECT MTL.ROWID ROW_ID
, MTL.DETAIL_TRANSACTION_ID
, MTL.ESTIMATE_DETAIL_ID
, MTL.LAST_UPDATE_DATE
, MTL.LAST_UPDATED_BY
, MTL.CREATION_DATE
, MTL.CREATED_BY
, MTL.LAST_UPDATE_LOGIN
, MTL.ORGANIZATION_ID
, ORG.ORGANIZATION_NAME
, MTL.SERIAL_NUMBER
, MTL.LOT_NUMBER
, MTL.LOCATOR_ID
, MTL.SUBINVENTORY_CODE
, MTL.REVISION
, MTL.TRANSACTION_TYPE_ID
, MTL.INTERFACE_TO_INVENTORY_FLAG
, MTL.ATTRIBUTE1
, MTL.ATTRIBUTE2
, MTL.ATTRIBUTE3
, MTL.ATTRIBUTE4
, MTL.ATTRIBUTE5
, MTL.ATTRIBUTE6
, MTL.ATTRIBUTE7
, MTL.ATTRIBUTE8
, MTL.ATTRIBUTE9
, MTL.ATTRIBUTE10
, MTL.ATTRIBUTE11
, MTL.ATTRIBUTE12
, MTL.ATTRIBUTE13
, MTL.ATTRIBUTE14
, MTL.ATTRIBUTE15
, MTL.CONTEXT
, ESTDTL.INVENTORY_ITEM_ID
, ESTDTL.QUANTITY_REQUIRED QUANTITY
, PAR.NEGATIVE_INV_RECEIPT_CODE
, SEC.LOCATOR_TYPE SUB_LOCATION_CONTROL_CODE
, PAR.STOCK_LOCATOR_CONTROL_CODE
, MTT.TRANSACTION_ACTION_ID ACTION_ID
, ESTDTL.UNIT_OF_MEASURE_CODE
FROM CS_EST_DETAILS_MTL_TXNS MTL
, CS_ESTIMATE_DETAILS ESTDTL
, MTL_PARAMETERS PAR
, MTL_SECONDARY_INVENTORIES SEC
, MTL_TRANSACTION_TYPES MTT
, HR_ORGANIZATION_INFORMATION HR
, ORG_ORGANIZATION_DEFINITIONS ORG
WHERE MTL.ESTIMATE_DETAIL_ID = ESTDTL.ESTIMATE_DETAIL_ID
AND HR.ORG_INFORMATION1 = 'INV'
AND HR.ORG_INFORMATION2 = 'Y'
AND HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND MTT.TRANSACTION_TYPE_ID = TO_NUMBER( FND_PROFILE.VALUE_SPECIFIC('CS_FIELD_SERVICE_TRANSACTION_TYPE'))
AND ORG.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND PAR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND SEC.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND SEC.SECONDARY_INVENTORY_NAME = NVL(MTL.SUBINVENTORY_CODE
, FND_PROFILE.VALUE_SPECIFIC('CS_FIELD_SERVICE_SUBINVENTORY'))