DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on WIP_REPETITIVE_ITEMS

Line 1861: WIP_REPETITIVE_ITEMS WRI

1857: ,SUPPLY_CUTOFF_DATE - FIRST_UNIT_COMPLETION_DATE)) - QUANTITY_COMPLETED)
1858: INTO QTY
1859: FROM
1860: WIP_REPETITIVE_SCHEDULES WRS,
1861: WIP_REPETITIVE_ITEMS WRI
1862: WHERE WRS.ORGANIZATION_ID = ORG_ID
1863: AND WRS.STATUS_TYPE IN ( 1 , 3 , 4 , 6 )
1864: AND WRI.ORGANIZATION_ID = ORG_ID
1865: AND WRI.PRIMARY_ITEM_ID = CURRENT_ITEM_ID