DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on GME_MATERIAL_DETAILS

Line 1563: GME_MATERIAL_DETAILS D,

1559: ,0) * (D.ORIGINAL_PRIMARY_QTY / D.ORIGINAL_QTY)) - NVL(MTR.PRIMARY_RESERVATION_QUANTITY
1560: ,0))
1561: INTO QTY
1562: FROM
1563: GME_MATERIAL_DETAILS D,
1564: GME_BATCH_HEADER H,
1565: MTL_RESERVATIONS MTR
1566: WHERE H.BATCH_TYPE IN ( 0 , 10 )
1567: AND H.BATCH_STATUS IN ( 1 , 2 )

Line 1820: GME_MATERIAL_DETAILS D,

1816: ,D.PLAN_QTY) - D.ACTUAL_QTY)
1817: ,0) * (ORIGINAL_PRIMARY_QTY / ORIGINAL_QTY))
1818: INTO QTY
1819: FROM
1820: GME_MATERIAL_DETAILS D,
1821: GME_BATCH_HEADER H
1822: WHERE H.BATCH_TYPE IN ( 0 , 10 )
1823: AND H.BATCH_STATUS IN ( 1 , 2 )
1824: AND H.BATCH_ID = D.BATCH_ID