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 1737: AND exists (SELECT 1 from mtl_txn_request_lines

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

Line 2126: -- and quantity delivered in mtl_txn_request_lines

2122: --
2123:
2124: -- kkoothan Part of Bug Fix: 2875583
2125: -- Converting the quantities to the primary uom as the quantity
2126: -- and quantity delivered in mtl_txn_request_lines
2127: -- are in transaction uom.
2128:
2129: --Bug 3057273, Move order demand should be excluded if net unreserved demand is No.
2130: if p_net_unrsv = 1 then

Line 2134: FROM MTL_TXN_REQUEST_LINES MTRL,

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

Line 2160: FROM MTL_TXN_REQUEST_LINES MTRL,

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

Line 2212: -- and quantity delivered in mtl_txn_request_lines

2208:
2209: IF (p_level = 2 and p_net_unrsv = 1) THEN
2210: -- kkoothan Part of Bug Fix: 2875583
2211: -- Converting the quantities to the primary uom as the quantity
2212: -- and quantity delivered in mtl_txn_request_lines
2213: -- are in transaction uom.
2214:
2215: /*SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2216: INTO qty

Line 2218: mtl_txn_request_lines mtrl

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

Line 2234: mtl_txn_request_lines mtrl

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

Line 2385: mtl_txn_request_lines mtrl

2381: -- Bug 3181367 added transaction_source_type_id 8 too.
2382: SELECT NVL(sum(mtrl.quantity - NVL(mtrl.quantity_delivered,0)),0)
2383: INTO l_pick_released_qty
2384: FROM mtl_txn_request_headers mtrh,
2385: mtl_txn_request_lines mtrl
2386: WHERE mtrh.move_order_type = 3
2387: AND mtrh.header_id = mtrl.header_id
2388: AND mtrl.organization_id = p_org_id
2389: AND mtrl.inventory_item_id = p_item_id