Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Stores WIP job information |
Implementation/DBA Data: | APPS.MRP_PLAN_JOBS_V |
SELECT JOBS.INVENTORY_ITEM_ID
, ORGS.ORGANIZATION_ID
, ORGS.COMPILE_DESIGNATOR
, ORGS.PLANNED_ORGANIZATION
, JOBS.WIP_ENTITY_ID
, JOBS.WIP_ENTITY_NAME
, JOBS.WIP_JOB_TYPE
, JOBS.MPS_JOB_QUANTITY
, JOBS.JOB_QUANTITY
, JOBS.NET_QUANTITY
, JOBS.MPS_NET_QUANTITY
, JOBS.MPS_SCHEDULED_COMPLETION_DATE
, JOBS.SCHEDULED_COMPLETION_DATE
, JOBS.QUANTITY_SCRAPPED
, JOBS.QUANTITY_COMPLETED
, JOBS.MPS_EXPECTED_SCRAP_QUANTITY
, JOBS.EXPECTED_SCRAP_QUANTITY
, JOBS.FIRM_PLANNED_STATUS_TYPE
, JOBS.START_DATE
, JOBS.REVISION
, JOBS.DEMAND_CLASS
, JOBS.STATUS_CODE
, ORGS.NET_WIP
, JOBS.PROJECT_ID
, JOBS.TASK_ID
, JOBS.SCHEDULE_GROUP_ID
, JOBS.BUILD_SEQUENCE
, JOBS.LINE_ID
, JOBS.ALTERNATE_BOM_DESIGNATOR
, JOBS.ALTERNATE_ROUTING_DESIGNATOR
, JOBS.FULL_PEGGING
, JOBS.ENTITY_TYPE
, JOBS.END_ITEM_UNIT_NUMBER
FROM MRP_WIP_JOBS_VIEW JOBS
, MRP_PLAN_ORGANIZATIONS_V ORGS
WHERE JOBS.ORGANIZATION_ID = ORGS.PLANNED_ORGANIZATION
AND JOBS.COMPILE_DESIGNATOR = ORGS.COMPILE_DESIGNATOR