[Home] [Help]
2405: mtl_reservations mr
2406: WHERE mr.organization_id = p_organization_id
2407: AND mr.inventory_item_id = p_item_id
2408: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2409: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2410: AND demand_source_header_id = p_batch_id
2411: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2412: AND subinventory_code LIKE (p_subinventory_code)
2413: AND NVL(mr.locator_id, -1) = NVL(NVL(p_locator_id, mr.locator_id), -1)
2443: WHERE mr.subinventory_code = msi.secondary_inventory_name
2444: AND mr.organization_id = p_organization_id
2445: AND mr.inventory_item_id = p_item_id
2446: AND demand_source_header_id = p_batch_id
2447: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2448: AND demand_source_line_id = p_material_detail_id
2449: AND subinventory_code LIKE (p_subinventory_code)
2450: AND msi.organization_id = p_organization_id;
2451:
2665: mtl_reservations mr
2666: WHERE mr.organization_id = p_organization_id
2667: AND mr.inventory_item_id = p_item_id
2668: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2669: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2670: AND mr.demand_source_header_id = p_batch_id
2671: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2672: AND mr.subinventory_code = p_subinventory_code
2673: AND a.concatenated_segments LIKE (p_locator)
2701: mtl_reservations mr
2702: WHERE mr.locator_id = a.inventory_location_id
2703: AND mr.organization_id = p_organization_id
2704: AND mr.inventory_item_id = p_item_id
2705: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2706: AND mr.demand_source_header_id = p_batch_id
2707: AND demand_source_line_id = p_material_detail_id
2708: AND mr.subinventory_code = p_subinventory_code
2709: AND a.concatenated_segments LIKE (p_locator)
2875: AND mr.inventory_item_id = p_item_id
2876: AND mr.inventory_item_id = mln.inventory_item_id
2877: AND mr.lot_number LIKE (p_lot_number)
2878: AND mr.lot_number = mln.lot_number
2879: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2880: AND demand_source_header_id = p_batch_id
2881: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2882: AND subinventory_code = p_subinventory_code
2883: AND NVL(mr.locator_id, -1) = NVL(NVL(p_locator_id, mr.locator_id), -1)
2898: AND mr.inventory_item_id = p_item_id
2899: AND mr.inventory_item_id = mln.inventory_item_id
2900: AND mr.lot_number LIKE (p_lot_number)
2901: AND mr.lot_number = mln.lot_number
2902: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2903: AND demand_source_header_id = p_batch_id
2904: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2905: AND NOT EXISTS (SELECT 1
2906: FROM mtl_material_transactions_temp
2952: AND l2.lot_number LIKE (p_lot_number)
2953: AND m2.organization_id = p_organization_id
2954: AND m2.transaction_source_id = p_batch_id
2955: AND m2.trx_source_line_id = p_material_detail_id
2956: AND m2.transaction_source_type_id = gme_common_pvt.g_txn_source_type
2957: AND (p_revision IS NULL OR m2.revision = p_revision)
2958: GROUP BY m2.revision, l2.lot_number) l
2959: WHERE (p_line_type = -1 and l.txn_qty < 0) OR
2960: (p_line_type IN (1,2) and l.txn_qty > 0);
3805: FROM mtl_material_transactions
3806: WHERE organization_id = p_org_id
3807: AND transaction_source_id = p_batch_id
3808: AND trx_source_line_id = p_material_detail_id
3809: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
3810: AND revision LIKE (p_revision)
3811: GROUP BY revision
3812: HAVING (p_line_type = -1 AND SUM(transaction_quantity) < 0) OR
3813: (p_line_type IN (1,2) AND SUM(transaction_quantity) > 0)--rework