eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_MRPRPROP_XMLP_PKG dependencies on MTL_DEMAND

Line 1451: MTL_DEMAND

1447: ,0)
1448: ,COMPLETED_QUANTITY))
1449: INTO QTY
1450: FROM
1451: MTL_DEMAND
1452: WHERE RESERVATION_TYPE = 2
1453: AND DEMAND_SOURCE_TYPE NOT IN ( 2 , 8 , 12 )
1454: AND ORGANIZATION_ID = ORG_ID
1455: AND INVENTORY_ITEM_ID = ITEM_ID

Line 1653: MTL_DEMAND MTL

1649: SELECT
1650: WIP.WIP_ENTITY_ID
1651: FROM
1652: WIP_SO_ALLOCATIONS WIP,
1653: MTL_DEMAND MTL
1654: WHERE WIP_ENTITY_ID = O.WIP_ENTITY_ID
1655: AND WIP.ORGANIZATION_ID = ORG_ID
1656: AND WIP.ORGANIZATION_ID = MTL.ORGANIZATION_ID
1657: AND WIP.DEMAND_SOURCE_HEADER_ID = MTL.DEMAND_SOURCE_HEADER_ID

Line 1657: AND WIP.DEMAND_SOURCE_HEADER_ID = MTL.DEMAND_SOURCE_HEADER_ID

1653: MTL_DEMAND MTL
1654: WHERE WIP_ENTITY_ID = O.WIP_ENTITY_ID
1655: AND WIP.ORGANIZATION_ID = ORG_ID
1656: AND WIP.ORGANIZATION_ID = MTL.ORGANIZATION_ID
1657: AND WIP.DEMAND_SOURCE_HEADER_ID = MTL.DEMAND_SOURCE_HEADER_ID
1658: AND WIP.DEMAND_SOURCE_LINE = MTL.DEMAND_SOURCE_LINE
1659: AND WIP.DEMAND_SOURCE_DELIVERY = MTL.DEMAND_SOURCE_DELIVERY
1660: AND MTL.INVENTORY_ITEM_ID = ITEM_ID );
1661: TOTAL := TOTAL + NVL(QTY

Line 1658: AND WIP.DEMAND_SOURCE_LINE = MTL.DEMAND_SOURCE_LINE

1654: WHERE WIP_ENTITY_ID = O.WIP_ENTITY_ID
1655: AND WIP.ORGANIZATION_ID = ORG_ID
1656: AND WIP.ORGANIZATION_ID = MTL.ORGANIZATION_ID
1657: AND WIP.DEMAND_SOURCE_HEADER_ID = MTL.DEMAND_SOURCE_HEADER_ID
1658: AND WIP.DEMAND_SOURCE_LINE = MTL.DEMAND_SOURCE_LINE
1659: AND WIP.DEMAND_SOURCE_DELIVERY = MTL.DEMAND_SOURCE_DELIVERY
1660: AND MTL.INVENTORY_ITEM_ID = ITEM_ID );
1661: TOTAL := TOTAL + NVL(QTY
1662: ,0);

Line 1659: AND WIP.DEMAND_SOURCE_DELIVERY = MTL.DEMAND_SOURCE_DELIVERY

1655: AND WIP.ORGANIZATION_ID = ORG_ID
1656: AND WIP.ORGANIZATION_ID = MTL.ORGANIZATION_ID
1657: AND WIP.DEMAND_SOURCE_HEADER_ID = MTL.DEMAND_SOURCE_HEADER_ID
1658: AND WIP.DEMAND_SOURCE_LINE = MTL.DEMAND_SOURCE_LINE
1659: AND WIP.DEMAND_SOURCE_DELIVERY = MTL.DEMAND_SOURCE_DELIVERY
1660: AND MTL.INVENTORY_ITEM_ID = ITEM_ID );
1661: TOTAL := TOTAL + NVL(QTY
1662: ,0);
1663: END IF;