Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, 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 by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 6 Vote(s) - 3.17 Average
  • 1
  • 2
  • 3
  • 4
  • 5
WIP Component Quanity required and Quanity Issues
#1
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,095 01-19-2015, 09:56 PM
Last Post: Kashif Manzoor



Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!