Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Sunday, 10 November 2019

Query to Get WIP Discrete Job Details in Oracle Apps R12


SELECT wip.wip_entity_name WO_NUMBER,
  msi.description,
  wip.start_quantity qty,
  msi.segment1 part_number,
  (SELECT OPERATION_DESCRIPTION
  FROM
    (SELECT BOS.OPERATION_SEQ_NUM,
      BOS.OPERATION_DESCRIPTION
    FROM APPS.BOM_OPERATIONAL_ROUTINGS BOR,
      APPS.BOM_OPERATION_SEQUENCES BOS
    WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
    AND BOR.ORGANIZATION_ID       = WIP.ORGANIZATION_ID
    AND BOR.ASSEMBLY_ITEM_ID      = WIP.PRIMARY_ITEM_ID
    AND UPPER(BOS.OPERATION_DESCRIPTION) LIKE 'S/U%PRESS%'
    ORDER BY BOS.OPERATION_SEQ_NUM
    )
  WHERE ROWNUM = 1
  ) SETUP_OP_DESC,
  NVL(wip.date_released,wip.creation_date) released_creation_date,
  wip.job_type_meaning wo_type,
  wip.status_type_disp,
  TO_CHAR(wip.scheduled_start_date,'DD-MON-YYYY') start_date,
  TO_CHAR(wip.scheduled_completion_date,'DD-MON-YYYY') comp_date,
  TO_CHAR(wip.date_released,'DD-MON-YYYY HH24:MI:SS') date_released,
  TO_CHAR(wip.creation_date,'DD-MON-YYYY HH24:MI:SS') creation_date
FROM apps.wip_discrete_jobs_v wip,
  apps.mtl_parameters mp,
  apps.mtl_system_items_b msi
WHERE mp.organization_id  = msi.organization_id
AND mp.organization_id    = wip.organization_id
AND msi.inventory_item_id = wip.primary_item_id

Share this article :

0 comments:

Post a Comment