+- Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities (http://www.oraerp.com)
+-- Forum: Oracle Applications (http://www.oraerp.com/forum-39.html)
+--- Forum: Oracle Tutorials, Articles, eBooks, Tools & Tips (http://www.oraerp.com/forum-12.html)
+--- Thread: WIP Component Quanity required and Quanity Issues (/thread-71193.html)
WIP Component Quanity required and Quanity Issues - shirfanarshad - 10-24-2014
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