Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Select
we.WIP_ENTITY_NAME JOB_NAME
, wdj.ATTRIBUTE4 Sales_Order
, wdj.ATTRIBUTE1 Customer_Name
, wdj.ATTRIBUTE2 Special_Instruction1
, wdj.ATTRIBUTE3 Special_Instruction2
, (select segment1 from mtl_system_items msi where msi.INVENTORY_ITEM_ID = we.PRIMARY_ITEM_ID and msi.ORGANIZATION_ID = we.ORGANIZATION_ID) Assembly_Item
, (select description from mtl_system_items msi where msi.INVENTORY_ITEM_ID = we.PRIMARY_ITEM_ID and msi.ORGANIZATION_ID = we.ORGANIZATION_ID) Assembly_Item_Description
, wdj.START_QUANTITY, wdj.QUANTITY_COMPLETED
, wdj.SCHEDULED_START_DATE, wdj.SCHEDULED_COMPLETION_DATE
, wdj.DATE_RELEASED
, wdj.DATE_COMPLETED
, wdj.DATE_CLOSED
, wdj.START_QUANTITY, wdj.QUANTITY_COMPLETED
, wqo.SEGMENT1 Component
,  REQUIRED_QUANTITY
,  QUANTITY_ISSUED
from wip_entities we, WIP_REQUIREMENT_OPERATIONS wqo, WIP_DISCRETE_JOBS wdj
where
we.WIP_ENTITY_ID = wqo.WIP_ENTITY_ID
and we.ORGANIZATION_ID = wqo.ORGANIZATION_ID
and we.WIP_ENTITY_ID = wdj.WIP_ENTITY_ID
and we.ORGANIZATION_ID = wdj.ORGANIZATION_ID 
and we.WIP_ENTITY_NAME = :JOB_name