APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 347: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL

343: l_ind NUMBER;
344:
345: CURSOR GET_TEMP_SEQ
346: IS
347: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
348: FROM FND_DUAL;
349:
350: l_temp_seq NUMBER;
351: l_head_seq NUMBER := NULL;

Line 383: FROM mtl_material_transactions mmt

379:
380: -- Bug 5533886
381: Cursor get_batch_transactions IS
382: SELECT *
383: FROM mtl_material_transactions mmt
384: WHERE transaction_source_id = p_batch_id
385: AND transaction_source_type_id = 5 -- gme_common_pvt.g_txn_source_type
386: AND NOT EXISTS ( SELECT transaction_id1
387: FROM gme_transaction_pairs

Line 404: x_batch_txns mtl_material_transactions%ROWTYPE;

400: FROM mtl_transaction_lot_numbers
401: WHERE transaction_id = v_transaction_id
402: AND lot_number = p_lot_uom_conv_rec.lot_number;
403:
404: x_batch_txns mtl_material_transactions%ROWTYPE;
405: x_lot_txns mtl_transaction_lot_numbers%ROWTYPE;
406: l_lot_transactions_tbl GME_COMMON_PVT.mtl_trans_lots_num_tbl;
407: i NUMBER;
408: j NUMBER;

Line 866: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (

862: /*=============================
863: Insert to Temp Table.
864: =============================*/
865:
866: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP (
867: transaction_header_id,
868: transaction_temp_id,
869: transaction_type_id,
870: transaction_action_id,

Line 1495: FROM mtl_material_transactions_temp

1491: ============================================*/
1492:
1493: CURSOR c_check_mmtt IS
1494: SELECT 1
1495: FROM mtl_material_transactions_temp
1496: WHERE lot_number = p_lot_number
1497: AND inventory_item_id = p_inventory_item_id
1498: AND organization_id = p_organization_id;
1499:

Line 1502: FROM mtl_material_transactions_temp

1498: AND organization_id = p_organization_id;
1499:
1500: CURSOR c_check_mmtt_head IS
1501: SELECT 1
1502: FROM mtl_material_transactions_temp
1503: WHERE lot_number = p_lot_number
1504: AND inventory_item_id = p_inventory_item_id
1505: AND organization_id = p_organization_id
1506: AND transaction_header_id <> p_header_id