[Home] [Help]
2378: mtl_reservations mr
2379: WHERE mr.organization_id = p_organization_id
2380: AND mr.inventory_item_id = p_item_id
2381: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2382: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2383: AND demand_source_header_id = p_batch_id
2384: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2385: AND subinventory_code LIKE (p_subinventory_code)
2386: AND NVL(mr.locator_id, -1) = NVL(NVL(p_locator_id, mr.locator_id), -1)
2416: WHERE mr.subinventory_code = msi.secondary_inventory_name
2417: AND mr.organization_id = p_organization_id
2418: AND mr.inventory_item_id = p_item_id
2419: AND demand_source_header_id = p_batch_id
2420: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2421: AND demand_source_line_id = p_material_detail_id
2422: AND subinventory_code LIKE (p_subinventory_code)
2423: AND msi.organization_id = p_organization_id;
2424:
2638: mtl_reservations mr
2639: WHERE mr.organization_id = p_organization_id
2640: AND mr.inventory_item_id = p_item_id
2641: AND NVL(mr.lot_number,0) = NVL(NVL(p_lot_number, mr.lot_number),0)
2642: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2643: AND mr.demand_source_header_id = p_batch_id
2644: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2645: AND mr.subinventory_code = p_subinventory_code
2646: AND a.concatenated_segments LIKE (p_locator)
2674: mtl_reservations mr
2675: WHERE mr.locator_id = a.inventory_location_id
2676: AND mr.organization_id = p_organization_id
2677: AND mr.inventory_item_id = p_item_id
2678: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2679: AND mr.demand_source_header_id = p_batch_id
2680: AND demand_source_line_id = p_material_detail_id
2681: AND mr.subinventory_code = p_subinventory_code
2682: AND a.concatenated_segments LIKE (p_locator)
2848: AND mr.inventory_item_id = p_item_id
2849: AND mr.inventory_item_id = mln.inventory_item_id
2850: AND mr.lot_number LIKE (p_lot_number)
2851: AND mr.lot_number = mln.lot_number
2852: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2853: AND demand_source_header_id = p_batch_id
2854: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2855: AND subinventory_code = p_subinventory_code
2856: AND NVL(mr.locator_id, -1) = NVL(NVL(p_locator_id, mr.locator_id), -1)
2871: AND mr.inventory_item_id = p_item_id
2872: AND mr.inventory_item_id = mln.inventory_item_id
2873: AND mr.lot_number LIKE (p_lot_number)
2874: AND mr.lot_number = mln.lot_number
2875: AND demand_source_type_id = gme_common_pvt.g_txn_source_type
2876: AND demand_source_header_id = p_batch_id
2877: AND NVL(demand_source_line_id, -1) = NVL(p_material_detail_id, -1)
2878: AND NOT EXISTS (SELECT 1
2879: FROM mtl_material_transactions_temp
2925: AND l2.lot_number LIKE (p_lot_number)
2926: AND m2.organization_id = p_organization_id
2927: AND m2.transaction_source_id = p_batch_id
2928: AND m2.trx_source_line_id = p_material_detail_id
2929: AND m2.transaction_source_type_id = gme_common_pvt.g_txn_source_type
2930: AND (p_revision IS NULL OR m2.revision = p_revision)
2931: GROUP BY m2.revision, l2.lot_number) l
2932: WHERE (p_line_type = -1 and l.txn_qty < 0) OR
2933: (p_line_type IN (1,2) and l.txn_qty > 0);
3721: FROM mtl_material_transactions
3722: WHERE organization_id = p_org_id
3723: AND transaction_source_id = p_batch_id
3724: AND trx_source_line_id = p_material_detail_id
3725: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
3726: AND revision LIKE (p_revision)
3727: GROUP BY revision
3728: HAVING (p_line_type = -1 AND SUM(transaction_quantity) < 0) OR
3729: (p_line_type IN (1,2) AND SUM(transaction_quantity) > 0)--rework