Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 8 Vote(s) - 3.63 Average
  • 1
  • 2
  • 3
  • 4
  • 5
WIP Component Quanity required and Quanity Issues
10-24-2014, 06:57 PM,
#1
WIP Component Quanity required and Quanity Issues
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
 
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle EBS R12.1.3 Upgrade from 11i Detailed DBA Tasks with Downtime required Kashif Manzoor 0 1,935 01-19-2015, 10:56 PM
Last Post: Kashif Manzoor



Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!