VIEW: APPS.MRP_PLAN_JOBS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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