[Home] [Help]
77: AND mr.demand_source_type_id = 5
78: AND mr.demand_source_header_id = p_batch_id
79: AND mr.demand_source_line_id = p_material_detail_id
80: AND NOT EXISTS (SELECT 1
81: FROM mtl_material_transactions_temp
82: WHERE reservation_id = mr.reservation_id)
83: ORDER BY mr.requirement_date, mr.reservation_id;
84:
85: END Rsrv_LoV;
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)
2857: AND NOT EXISTS (SELECT 1
2858: FROM mtl_material_transactions_temp
2859: WHERE reservation_id = mr.reservation_id);
2860: ELSE
2861:
2862: OPEN x_lot_num_lov FOR
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
2880: WHERE reservation_id = mr.reservation_id);
2881: END IF;
2882:
2883: END Lot_LoV_Rsrv;
2918: (SELECT m2.revision,
2919: l2.lot_number lot_num,
2920: SUM(l2.primary_quantity) txn_qty,
2921: SUM(NVL(l2.secondary_transaction_quantity,0)) txn_sec_qty
2922: FROM mtl_material_transactions m2,
2923: mtl_transaction_lot_numbers l2
2924: WHERE l2.transaction_id = m2.transaction_id
2925: AND l2.lot_number LIKE (p_lot_number)
2926: AND m2.organization_id = p_organization_id
3717: IS
3718: BEGIN
3719: OPEN x_revision_cursor FOR
3720: SELECT DISTINCT revision
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