DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on WIP_DISCRETE_JOBS

Line 1631: WIP_DISCRETE_JOBS D,

1627: SELECT
1628: SUM(O.REQUIRED_QUANTITY - O.QUANTITY_ISSUED)
1629: INTO QTY
1630: FROM
1631: WIP_DISCRETE_JOBS D,
1632: WIP_REQUIREMENT_OPERATIONS O
1633: WHERE O.WIP_ENTITY_ID = D.WIP_ENTITY_ID
1634: AND O.ORGANIZATION_ID = D.ORGANIZATION_ID
1635: AND D.ORGANIZATION_ID = ORG_ID

Line 1839: WIP_DISCRETE_JOBS

1835: ,0) - NVL(QUANTITY_SCRAPPED
1836: ,0))
1837: INTO QTY
1838: FROM
1839: WIP_DISCRETE_JOBS
1840: WHERE ORGANIZATION_ID = ORG_ID
1841: AND PRIMARY_ITEM_ID = CURRENT_ITEM_ID
1842: AND STATUS_TYPE in ( 1 , 3 , 4 , 6 )
1843: AND JOB_TYPE in ( 1 , 3 )