DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 75: SELECT mtl_material_transactions_s.NEXTVAL

71: print_debug('init_startup_values : 20', 4);
72: END IF;
73:
74: IF g_rcv_global_var.transaction_header_id IS NULL THEN
75: SELECT mtl_material_transactions_s.NEXTVAL
76: INTO g_rcv_global_var.transaction_header_id
77: FROM DUAL;
78: END IF;
79:

Line 1214: SELECT mtl_material_transactions_s.NEXTVAL

1210: l_mtlt_rec.primary_quantity := l_new_primary_quantity;
1211: l_transaction_quantity := l_mtlt_rec.transaction_quantity;
1212: l_mtlt_rec.secondary_quantity := l_new_secondary_quantity;
1213:
1214: SELECT mtl_material_transactions_s.NEXTVAL
1215: INTO l_mtlt_rec.serial_transaction_temp_id
1216: FROM DUAL;
1217:
1218: l_mtlt_rec.transaction_quantity := l_transaction_quantity * l_new_primary_quantity / l_primary_quantity;

Line 3263: SELECT mtl_material_transactions_s.NEXTVAL

3259: WHERE transaction_temp_id = p_transaction_temp_id
3260: AND lot_number = p_lot_number;
3261: ELSE
3262: IF p_transaction_temp_id IS NULL THEN
3263: SELECT mtl_material_transactions_s.NEXTVAL
3264: INTO p_transaction_temp_id
3265: FROM DUAL;
3266: END IF;
3267:

Line 3412: SELECT mtl_material_transactions_s.NEXTVAL

3408:
3409: IF p_serial_transaction_temp_id IS NULL THEN
3410: l_progress := '40';
3411:
3412: SELECT mtl_material_transactions_s.NEXTVAL
3413: INTO p_serial_transaction_temp_id
3414: FROM DUAL;
3415:
3416: l_progress := '50';