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_TXN_REQUEST_LINES

Line 1170: -- and quantity delivered in mtl_txn_request_lines

1166:
1167: IF (p_level = 2 and p_include_mo = 1) THEN
1168: -- kkoothan Part of Bug Fix: 2875583
1169: -- Converting the quantities to the primary uom as the quantity
1170: -- and quantity delivered in mtl_txn_request_lines
1171: -- are in transaction uom.
1172:
1173: /* SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
1174: INTO l_qty

Line 1176: mtl_txn_request_lines mtrl

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
1180: AND mtrl.inventory_item_id = p_item_id

Line 1193: mtl_txn_request_lines mtrl

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
1197: AND mtrl.inventory_item_id = p_item_id

Line 1740: AND exists (SELECT 1 from mtl_txn_request_lines

1736: AND transaction_source_type_id in (2,8)
1737: AND not exists (SELECT 1 from mtl_reservations
1738: WHERE reservation_id = mmtt.reservation_id
1739: AND nvl(subinventory_code, '@@@') = p_subinv)
1740: AND exists (SELECT 1 from mtl_txn_request_lines
1741: WHERE line_id = mmtt.move_order_line_id
1742: AND from_subinventory_code is null
1743: AND line_status NOT IN (5,6)
1744: AND date_required <= p_d_cutoff + 0.99999); /* bug no 6009682 */

Line 2136: -- and quantity delivered in mtl_txn_request_lines

2132: --
2133:
2134: -- kkoothan Part of Bug Fix: 2875583
2135: -- Converting the quantities to the primary uom as the quantity
2136: -- and quantity delivered in mtl_txn_request_lines
2137: -- are in transaction uom.
2138:
2139: --Bug 3057273, Move order demand should be excluded if net unreserved demand is No.
2140: if p_net_unrsv = 1 then

Line 2144: FROM MTL_TXN_REQUEST_LINES MTRL,

2140: if p_net_unrsv = 1 then
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

Line 2170: FROM MTL_TXN_REQUEST_LINES MTRL,

2166: , mtrl.uom_code
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

Line 2222: -- and quantity delivered in mtl_txn_request_lines

2218:
2219: IF (p_level = 2 and p_net_unrsv = 1) THEN
2220: -- kkoothan Part of Bug Fix: 2875583
2221: -- Converting the quantities to the primary uom as the quantity
2222: -- and quantity delivered in mtl_txn_request_lines
2223: -- are in transaction uom.
2224:
2225: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2226: INTO qty

Line 2228: mtl_txn_request_lines mtrl

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
2232: AND mtrl.inventory_item_id = p_item_id

Line 2244: mtl_txn_request_lines mtrl

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
2248: AND mtrl.inventory_item_id = p_item_id

Line 2395: mtl_txn_request_lines mtrl

2391: -- Bug 3181367 added transaction_source_type_id 8 too.
2392: SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2393: INTO l_pick_released_qty
2394: FROM mtl_txn_request_headers mtrh,
2395: mtl_txn_request_lines mtrl
2396: WHERE mtrh.move_order_type = 3
2397: AND mtrh.header_id = mtrl.header_id
2398: AND mtrl.organization_id = p_org_id
2399: AND mtrl.inventory_item_id = p_item_id