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.INV_MINMAX_PVT dependencies on MTL_TRANSACTION_TYPES

Line 1175: FROM mtl_transaction_types mtt,

1171: -- are in transaction uom.
1172:
1173: /* SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
1174: INTO l_qty
1175: FROM mtl_transaction_types mtt,
1176: mtl_txn_request_lines mtrl
1177: WHERE mtt.transaction_action_id IN (2,28)
1178: AND mtt.transaction_type_id = mtrl.transaction_type_id
1179: AND mtrl.organization_id = p_org_id

Line 1192: FROM mtl_transaction_types mtt,

1188: , mtrl.uom_code
1189: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
1190: ),0)
1191: INTO l_qty
1192: FROM mtl_transaction_types mtt,
1193: mtl_txn_request_lines mtrl
1194: WHERE mtt.transaction_action_id IN (2,28)
1195: AND mtt.transaction_type_id = mtrl.transaction_type_id
1196: AND mtrl.organization_id = p_org_id

Line 2135: MTL_TRANSACTION_TYPES MTT

2131:
2132: /*SELECT SUM(MTRL.QUANTITY - NVL(MTRL.QUANTITY_DELIVERED,0))
2133: INTO qty
2134: FROM MTL_TXN_REQUEST_LINES MTRL,
2135: MTL_TRANSACTION_TYPES MTT
2136: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2137: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2138: AND MTRL.ORGANIZATION_ID = p_org_id
2139: AND MTRL.INVENTORY_ITEM_ID = p_item_id

Line 2161: MTL_TRANSACTION_TYPES MTT

2157: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2158: ),0)
2159: INTO qty
2160: FROM MTL_TXN_REQUEST_LINES MTRL,
2161: MTL_TRANSACTION_TYPES MTT
2162: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2163: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2164: AND MTRL.ORGANIZATION_ID = p_org_id
2165: AND MTRL.INVENTORY_ITEM_ID = p_item_id

Line 2217: FROM mtl_transaction_types mtt,

2213: -- are in transaction uom.
2214:
2215: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2216: INTO qty
2217: FROM mtl_transaction_types mtt,
2218: mtl_txn_request_lines mtrl
2219: WHERE mtt.transaction_action_id IN (2,28)
2220: AND mtt.transaction_type_id = mtrl.transaction_type_id
2221: AND mtrl.organization_id = p_org_id

Line 2233: FROM mtl_transaction_types mtt,

2229: ,mtrl.uom_code
2230: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2231: ),0)
2232: INTO qty
2233: FROM mtl_transaction_types mtt,
2234: mtl_txn_request_lines mtrl
2235: WHERE mtt.transaction_action_id IN (2,28)
2236: AND mtt.transaction_type_id = mtrl.transaction_type_id
2237: AND mtrl.organization_id = p_org_id