VIEW: APPS.WSM_WIP_GENEALOGY_LOTATTR_V

Source

View Text - Preformatted

SELECT dsj.wip_entity_id, dsj.wip_entity_name, dsj.organization_id, org.organization_code, hou.name organization_name, dsj.status_type_disp status_type, msi.concatenated_segments item_number, msi.description item_description, dsj.firm_planned_flag, dsj.class_code, dsj.scheduled_start_date, dsj.date_released, dsj.scheduled_completion_date, dsj.date_completed, dsj.date_closed, dsj.start_quantity, dsj.quantity_remaining, dsj.quantity_completed, dsj.quantity_scrapped, dsj.net_quantity, dsj.completion_subinventory, dsj.job_type, 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, msi.INVENTORY_ITEM_ID,msi.PRIMARY_UOM_CODE UOM,1 line_type FROM mtl_parameters org, hr_organization_units hou, wip_discrete_jobs_v dsj, mtl_system_items_kfv msi, mtl_lot_numbers mln WHERE dsj.primary_item_id = msi.inventory_item_id (+) and dsj.organization_id = msi.organization_id (+) and dsj.organization_id = org.organization_id and org.organization_id = hou.organization_id and dsj.lot_number = mln.lot_number (+) and dsj.primary_item_id = mln.inventory_item_id (+) and dsj.organization_id = mln.organization_id (+)

View Text - HTML Formatted

SELECT DSJ.WIP_ENTITY_ID
, DSJ.WIP_ENTITY_NAME
, DSJ.ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, HOU.NAME ORGANIZATION_NAME
, DSJ.STATUS_TYPE_DISP STATUS_TYPE
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, DSJ.FIRM_PLANNED_FLAG
, DSJ.CLASS_CODE
, DSJ.SCHEDULED_START_DATE
, DSJ.DATE_RELEASED
, DSJ.SCHEDULED_COMPLETION_DATE
, DSJ.DATE_COMPLETED
, DSJ.DATE_CLOSED
, DSJ.START_QUANTITY
, DSJ.QUANTITY_REMAINING
, DSJ.QUANTITY_COMPLETED
, DSJ.QUANTITY_SCRAPPED
, DSJ.NET_QUANTITY
, DSJ.COMPLETION_SUBINVENTORY
, DSJ.JOB_TYPE
, 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
, MSI.INVENTORY_ITEM_ID
, MSI.PRIMARY_UOM_CODE UOM
, 1 LINE_TYPE
FROM MTL_PARAMETERS ORG
, HR_ORGANIZATION_UNITS HOU
, WIP_DISCRETE_JOBS_V DSJ
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_LOT_NUMBERS MLN
WHERE DSJ.PRIMARY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND DSJ.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND DSJ.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND DSJ.LOT_NUMBER = MLN.LOT_NUMBER (+)
AND DSJ.PRIMARY_ITEM_ID = MLN.INVENTORY_ITEM_ID (+)
AND DSJ.ORGANIZATION_ID = MLN.ORGANIZATION_ID (+)