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 2145: MTL_TRANSACTION_TYPES MTT

2141:
2142: /*SELECT SUM(MTRL.QUANTITY - NVL(MTRL.QUANTITY_DELIVERED,0))
2143: INTO qty
2144: FROM MTL_TXN_REQUEST_LINES MTRL,
2145: MTL_TRANSACTION_TYPES MTT
2146: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2147: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2148: AND MTRL.ORGANIZATION_ID = p_org_id
2149: AND MTRL.INVENTORY_ITEM_ID = p_item_id

Line 2171: MTL_TRANSACTION_TYPES MTT

2167: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2168: ),0)
2169: INTO qty
2170: FROM MTL_TXN_REQUEST_LINES MTRL,
2171: MTL_TRANSACTION_TYPES MTT
2172: WHERE MTT.TRANSACTION_TYPE_ID = MTRL.TRANSACTION_TYPE_ID
2173: AND MTRL.TRANSACTION_TYPE_ID <> INV_Globals.G_TYPE_XFER_ORDER_WIP_ISSUE
2174: AND MTRL.ORGANIZATION_ID = p_org_id
2175: AND MTRL.INVENTORY_ITEM_ID = p_item_id

Line 2227: FROM mtl_transaction_types mtt,

2223: -- are in transaction uom.
2224:
2225: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2226: INTO qty
2227: FROM mtl_transaction_types mtt,
2228: mtl_txn_request_lines mtrl
2229: WHERE mtt.transaction_action_id IN (2,28)
2230: AND mtt.transaction_type_id = mtrl.transaction_type_id
2231: AND mtrl.organization_id = p_org_id

Line 2243: FROM mtl_transaction_types mtt,

2239: ,mtrl.uom_code
2240: , mtrl.quantity - NVL(mtrl.quantity_delivered,0))
2241: ),0)
2242: INTO qty
2243: FROM mtl_transaction_types mtt,
2244: mtl_txn_request_lines mtrl
2245: WHERE mtt.transaction_action_id IN (2,28)
2246: AND mtt.transaction_type_id = mtrl.transaction_type_id
2247: AND mtrl.organization_id = p_org_id