[Home] [Help]
751: mmt.reason_id,
752: mmt.transaction_action_id,
753: msi.mrp_planning_code
754: )mmt1,
755: WIP_ENTITIES we,
756: WIP_DISCRETE_JOBS wdj
757: where
758: mta1.transaction_id = mmt1.transaction_id and
759: mta1.organization_id = mmt1.organization_id and
992: mmt.reason_id,
993: mmt.transaction_action_id,
994: msi.mrp_planning_code
995: )mmt1,
996: WIP_ENTITIES we,
997: WIP_DISCRETE_JOBS wdj
998: where
999: mta1.transaction_id = mmt1.transaction_id and
1000: mta1.organization_id = mmt1.organization_id and
2112: WRO.WIP_ENTITY_ID JOB_ID,
2113: decode(WE.ENTITY_TYPE,5,5,8,5,1) JOB_TYPE,
2114: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2115: FROM
2116: WIP_ENTITIES WE,
2117: WIP_REQUIREMENT_OPERATIONS WRO
2118: WHERE
2119: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2120: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2132: WRO.REPETITIVE_SCHEDULE_ID JOB_ID,
2133: 2 JOB_TYPE,
2134: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2135: FROM
2136: WIP_ENTITIES WE,
2137: WIP_REQUIREMENT_OPERATIONS WRO
2138: WHERE
2139: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2140: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2339: WRO.WIP_ENTITY_ID JOB_ID,
2340: decode(WE.ENTITY_TYPE,5,5,8,5,1) JOB_TYPE,
2341: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2342: FROM
2343: WIP_ENTITIES WE,
2344: WIP_REQUIREMENT_OPERATIONS WRO
2345: WHERE
2346: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2347: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND
2359: WRO.REPETITIVE_SCHEDULE_ID JOB_ID,
2360: 2 JOB_TYPE,
2361: SUM(WRO.REQUIRED_QUANTITY) Standard_Quantity
2362: FROM
2363: WIP_ENTITIES WE,
2364: WIP_REQUIREMENT_OPERATIONS WRO
2365: WHERE
2366: WRO.ORGANIZATION_ID = WE.ORGANIZATION_ID AND
2367: WRO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID AND