[Home] [Help]
97: AND mr.demand_source_header_id = p_batch_id
98: AND mr.demand_source_line_id = p_material_detail_id
99: AND LPN.lpn_id(+) = mr.lpn_id
100: AND NOT EXISTS (SELECT 1
101: FROM mtl_material_transactions_temp
102: WHERE reservation_id = mr.reservation_id)
103: ORDER BY mr.requirement_date, mr.reservation_id;
104:
105: END Rsrv_LoV;
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)
2884: AND NOT EXISTS (SELECT 1
2885: FROM mtl_material_transactions_temp
2886: WHERE reservation_id = mr.reservation_id);
2887: ELSE
2888:
2889: OPEN x_lot_num_lov FOR
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
2907: WHERE reservation_id = mr.reservation_id);
2908: END IF;
2909:
2910: END Lot_LoV_Rsrv;
2945: (SELECT m2.revision,
2946: l2.lot_number lot_num,
2947: SUM(l2.primary_quantity) txn_qty,
2948: SUM(NVL(l2.secondary_transaction_quantity,0)) txn_sec_qty
2949: FROM mtl_material_transactions m2,
2950: mtl_transaction_lot_numbers l2
2951: WHERE l2.transaction_id = m2.transaction_id
2952: AND l2.lot_number LIKE (p_lot_number)
2953: AND m2.organization_id = p_organization_id
3801: IS
3802: BEGIN
3803: OPEN x_revision_cursor FOR
3804: SELECT DISTINCT revision
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