View: MTL_MFG_BATCHES_SECURITY_V

Product:	INV - Inventory
Description:	View of gme batches with securities for genealogy
Implementation/DBA Data:	APPS.MTL_MFG_BATCHES_SECURITY_V

View Text

SELECT NULL ROW_ID
, GHDR.BATCH_ID WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME WIP_ENTITY_NAME
, GHDR.BATCH_STATUS STATUS_TYPE
, WE.PRIMARY_ITEM_ID PRIMARY_ITEM_ID
, GHDR.PLAN_START_DATE SCHEDULED_START_DATE
, GHDR.PLAN_CMPLT_DATE SCHEDULED_COMPLETION_DATE
, LU1.MEANING STATUS_TYPE_DISP
, MSI.DESCRIPTION ASSEMBLY_DESCRIPTION
, GHDR.ORGANIZATION_ID
, NULL LOT_NUMBER
, NULL DISABLE_FLAG
, NULL EXPIRATION_DATE
, NULL VENDOR_NAME
, NULL SUPPLIER_LOT_NUMBER
, NULL GRADE_CODE
, NULL ORIGINATION_DATE
, NULL DATE_CODE
, NULL STATUS_ID
, NULL CHANGE_DATE
, NULL AGE
, NULL RETEST_DATE
, NULL MATURITY_DATE
, NULL LOT_ATTRIBUTE_CATEGORY
, NULL ITEM_SIZE
, NULL COLOR
, NULL VOLUME
, NULL VOLUME_UOM
, NULL PLACE_OF_ORIGIN
, NULL BEST_BY_DATE
, NULL LENGTH
, NULL LENGTH_UOM
, NULL RECYCLED_CONTENT
, NULL THICKNESS
, NULL THICKNESS_UOM
, NULL WIDTH
, NULL WIDTH_UOM
, NULL CURL_WRINKLE_FOLD
, NULL C_ATTRIBUTE1
, NULL C_ATTRIBUTE2
, NULL C_ATTRIBUTE3
, NULL C_ATTRIBUTE4
, NULL C_ATTRIBUTE5
, NULL C_ATTRIBUTE6
, NULL C_ATTRIBUTE7
, NULL C_ATTRIBUTE8
, NULL C_ATTRIBUTE9
, NULL C_ATTRIBUTE10
, NULL C_ATTRIBUTE11
, NULL C_ATTRIBUTE12
, NULL C_ATTRIBUTE13
, NULL C_ATTRIBUTE14
, NULL C_ATTRIBUTE15
, NULL C_ATTRIBUTE16
, NULL C_ATTRIBUTE17
, NULL C_ATTRIBUTE18
, NULL C_ATTRIBUTE19
, NULL C_ATTRIBUTE20
, NULL D_ATTRIBUTE1
, NULL D_ATTRIBUTE2
, NULL D_ATTRIBUTE3
, NULL D_ATTRIBUTE4
, NULL D_ATTRIBUTE5
, NULL D_ATTRIBUTE6
, NULL D_ATTRIBUTE7
, NULL D_ATTRIBUTE8
, NULL D_ATTRIBUTE9
, NULL D_ATTRIBUTE10
, NULL N_ATTRIBUTE1
, NULL N_ATTRIBUTE2
, NULL N_ATTRIBUTE3
, NULL N_ATTRIBUTE4
, NULL N_ATTRIBUTE5
, NULL N_ATTRIBUTE6
, NULL N_ATTRIBUTE7
, NULL N_ATTRIBUTE8
, NULL N_ATTRIBUTE9
, NULL N_ATTRIBUTE10
, NULL VENDOR_ID
, NULL TERRITORY_CODE
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
FROM GME_BATCH_HEADER_VW GHDR
, GEM_LOOKUPS LU1
, MTL_SYSTEM_ITEMS MSI
, WIP_ENTITIES WE
WHERE WE.WIP_ENTITY_ID = GHDR.BATCH_ID
AND LU1.LOOKUP_TYPE = 'BATCH_STATUS'
AND LU1.LOOKUP_CODE = GHDR.BATCH_STATUS
AND WE.PRIMARY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND WE.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Columns