DBA Data[Home] [Help]

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on GME_BATCH_HEADER

Line 1564: GME_BATCH_HEADER H,

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 )
1568: AND H.BATCH_ID = D.BATCH_ID

Line 1821: GME_BATCH_HEADER H

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
1825: AND D.INVENTORY_ITEM_ID = CURRENT_ITEM_ID