VIEW: APPS.WSM_DISCRETE_JOBS_LOTATTR_V

Source

View Text - Preformatted

SELECT WDJ.ROWID ROW_ID ,WDJ.WIP_ENTITY_ID ,WE.WIP_ENTITY_NAME , WDJ.STATUS_TYPE ,WDJ.PRIMARY_ITEM_ID ,WDJ.SCHEDULED_START_DATE , WDJ.SCHEDULED_COMPLETION_DATE ,LU1.MEANING STATUS_TYPE_DISP , MSI.DESCRIPTION ASSEMBLY_DESCRIPTION ,WDJ.ORGANIZATION_ID , mln.lot_number, mln.disable_flag, mln.expiration_date, mln.VENDOR_NAME, mln.SUPPLIER_LOT_NUMBER, mln.GRADE_CODE, mln.ORIGINATION_DATE, mln.DATE_CODE, mln.STATUS_ID, mln.CHANGE_DATE, mln.AGE, mln.RETEST_DATE, mln.MATURITY_DATE, mln.LOT_ATTRIBUTE_CATEGORY, mln.ITEM_SIZE, mln.COLOR, mln.VOLUME, mln.VOLUME_UOM, mln.PLACE_OF_ORIGIN, mln.BEST_BY_DATE, mln.LENGTH, mln.LENGTH_UOM, mln.RECYCLED_CONTENT, mln.THICKNESS, mln.THICKNESS_UOM, mln.WIDTH, mln.WIDTH_UOM, mln.CURL_WRINKLE_FOLD, mln.C_ATTRIBUTE1, mln.C_ATTRIBUTE2, mln.C_ATTRIBUTE3, mln.C_ATTRIBUTE4, mln.C_ATTRIBUTE5, mln.C_ATTRIBUTE6, mln.C_ATTRIBUTE7, mln.C_ATTRIBUTE8, mln.C_ATTRIBUTE9, mln.C_ATTRIBUTE10, mln.C_ATTRIBUTE11, mln.C_ATTRIBUTE12, mln.C_ATTRIBUTE13, mln.C_ATTRIBUTE14, mln.C_ATTRIBUTE15, mln.C_ATTRIBUTE16, mln.C_ATTRIBUTE17, mln.C_ATTRIBUTE18, mln.C_ATTRIBUTE19, mln.C_ATTRIBUTE20, mln.D_ATTRIBUTE1, mln.D_ATTRIBUTE2, mln.D_ATTRIBUTE3, mln.D_ATTRIBUTE4, mln.D_ATTRIBUTE5, mln.D_ATTRIBUTE6, mln.D_ATTRIBUTE7, mln.D_ATTRIBUTE8, mln.D_ATTRIBUTE9, mln.D_ATTRIBUTE10, mln.N_ATTRIBUTE1, mln.N_ATTRIBUTE2, mln.N_ATTRIBUTE3, mln.N_ATTRIBUTE4, mln.N_ATTRIBUTE5, mln.N_ATTRIBUTE6, mln.N_ATTRIBUTE7, mln.N_ATTRIBUTE8, mln.N_ATTRIBUTE9, mln.N_ATTRIBUTE10, mln.VENDOR_ID, mln.TERRITORY_CODE, mln.attribute_category, mln.ATTRIBUTE1, mln.ATTRIBUTE2, mln.ATTRIBUTE3, mln.ATTRIBUTE4, mln.ATTRIBUTE5, mln.ATTRIBUTE6, mln.ATTRIBUTE7, mln.ATTRIBUTE8, mln.ATTRIBUTE9, mln.ATTRIBUTE10, mln.ATTRIBUTE11, mln.ATTRIBUTE12, mln.ATTRIBUTE13, mln.ATTRIBUTE14, mln.ATTRIBUTE15 FROM MTL_SECONDARY_INVENTORIES MSUB , MFG_LOOKUPS LU1 , MFG_LOOKUPS LU2 , WIP_ENTITIES WE , WIP_DISCRETE_JOBS WDJ , WIP_LINES WL , WIP_SCHEDULE_GROUPS WSG , MTL_KANBAN_CARDS KC , MTL_SYSTEM_ITEMS MSI, MTL_LOT_NUMBERS MLN WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID AND MSUB.SECONDARY_INVENTORY_NAME (+) = WDJ.COMPLETION_SUBINVENTORY AND MSUB.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID AND WSG.SCHEDULE_GROUP_ID (+) = WDJ.SCHEDULE_GROUP_ID AND WL.LINE_ID (+) = WDJ.LINE_ID AND WL.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID AND LU2.LOOKUP_TYPE = 'WIP_SUPPLY' AND LU1.LOOKUP_TYPE = 'WIP_JOB_STATUS' AND LU1.LOOKUP_CODE = WDJ.STATUS_TYPE AND LU2.LOOKUP_CODE = WDJ.WIP_SUPPLY_TYPE AND KC.KANBAN_CARD_ID (+) = WDJ.KANBAN_CARD_ID AND WDJ.PRIMARY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+) AND WDJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+) AND wdj.lot_number = mln.lot_number (+) AND wdj.primary_item_id = mln.inventory_item_id (+) AND wdj.organization_id = mln.organization_id (+)

View Text - HTML Formatted

SELECT WDJ.ROWID ROW_ID
, WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WDJ.STATUS_TYPE
, WDJ.PRIMARY_ITEM_ID
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, LU1.MEANING STATUS_TYPE_DISP
, MSI.DESCRIPTION ASSEMBLY_DESCRIPTION
, WDJ.ORGANIZATION_ID
, MLN.LOT_NUMBER
, MLN.DISABLE_FLAG
, MLN.EXPIRATION_DATE
, MLN.VENDOR_NAME
, MLN.SUPPLIER_LOT_NUMBER
, MLN.GRADE_CODE
, MLN.ORIGINATION_DATE
, MLN.DATE_CODE
, MLN.STATUS_ID
, MLN.CHANGE_DATE
, MLN.AGE
, MLN.RETEST_DATE
, MLN.MATURITY_DATE
, MLN.LOT_ATTRIBUTE_CATEGORY
, MLN.ITEM_SIZE
, MLN.COLOR
, MLN.VOLUME
, MLN.VOLUME_UOM
, MLN.PLACE_OF_ORIGIN
, MLN.BEST_BY_DATE
, MLN.LENGTH
, MLN.LENGTH_UOM
, MLN.RECYCLED_CONTENT
, MLN.THICKNESS
, MLN.THICKNESS_UOM
, MLN.WIDTH
, MLN.WIDTH_UOM
, MLN.CURL_WRINKLE_FOLD
, MLN.C_ATTRIBUTE1
, MLN.C_ATTRIBUTE2
, MLN.C_ATTRIBUTE3
, MLN.C_ATTRIBUTE4
, MLN.C_ATTRIBUTE5
, MLN.C_ATTRIBUTE6
, MLN.C_ATTRIBUTE7
, MLN.C_ATTRIBUTE8
, MLN.C_ATTRIBUTE9
, MLN.C_ATTRIBUTE10
, MLN.C_ATTRIBUTE11
, MLN.C_ATTRIBUTE12
, MLN.C_ATTRIBUTE13
, MLN.C_ATTRIBUTE14
, MLN.C_ATTRIBUTE15
, MLN.C_ATTRIBUTE16
, MLN.C_ATTRIBUTE17
, MLN.C_ATTRIBUTE18
, MLN.C_ATTRIBUTE19
, MLN.C_ATTRIBUTE20
, MLN.D_ATTRIBUTE1
, MLN.D_ATTRIBUTE2
, MLN.D_ATTRIBUTE3
, MLN.D_ATTRIBUTE4
, MLN.D_ATTRIBUTE5
, MLN.D_ATTRIBUTE6
, MLN.D_ATTRIBUTE7
, MLN.D_ATTRIBUTE8
, MLN.D_ATTRIBUTE9
, MLN.D_ATTRIBUTE10
, MLN.N_ATTRIBUTE1
, MLN.N_ATTRIBUTE2
, MLN.N_ATTRIBUTE3
, MLN.N_ATTRIBUTE4
, MLN.N_ATTRIBUTE5
, MLN.N_ATTRIBUTE6
, MLN.N_ATTRIBUTE7
, MLN.N_ATTRIBUTE8
, MLN.N_ATTRIBUTE9
, MLN.N_ATTRIBUTE10
, MLN.VENDOR_ID
, MLN.TERRITORY_CODE
, MLN.ATTRIBUTE_CATEGORY
, MLN.ATTRIBUTE1
, MLN.ATTRIBUTE2
, MLN.ATTRIBUTE3
, MLN.ATTRIBUTE4
, MLN.ATTRIBUTE5
, MLN.ATTRIBUTE6
, MLN.ATTRIBUTE7
, MLN.ATTRIBUTE8
, MLN.ATTRIBUTE9
, MLN.ATTRIBUTE10
, MLN.ATTRIBUTE11
, MLN.ATTRIBUTE12
, MLN.ATTRIBUTE13
, MLN.ATTRIBUTE14
, MLN.ATTRIBUTE15
FROM MTL_SECONDARY_INVENTORIES MSUB
, MFG_LOOKUPS LU1
, MFG_LOOKUPS LU2
, WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_LINES WL
, WIP_SCHEDULE_GROUPS WSG
, MTL_KANBAN_CARDS KC
, MTL_SYSTEM_ITEMS MSI
, MTL_LOT_NUMBERS MLN
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND MSUB.SECONDARY_INVENTORY_NAME (+) = WDJ.COMPLETION_SUBINVENTORY
AND MSUB.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND WSG.SCHEDULE_GROUP_ID (+) = WDJ.SCHEDULE_GROUP_ID
AND WL.LINE_ID (+) = WDJ.LINE_ID
AND WL.ORGANIZATION_ID (+) = WDJ.ORGANIZATION_ID
AND LU2.LOOKUP_TYPE = 'WIP_SUPPLY'
AND LU1.LOOKUP_TYPE = 'WIP_JOB_STATUS'
AND LU1.LOOKUP_CODE = WDJ.STATUS_TYPE
AND LU2.LOOKUP_CODE = WDJ.WIP_SUPPLY_TYPE
AND KC.KANBAN_CARD_ID (+) = WDJ.KANBAN_CARD_ID
AND WDJ.PRIMARY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND WDJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND WDJ.LOT_NUMBER = MLN.LOT_NUMBER (+)
AND WDJ.PRIMARY_ITEM_ID = MLN.INVENTORY_ITEM_ID (+)
AND WDJ.ORGANIZATION_ID = MLN.ORGANIZATION_ID (+)