APPS.CONVERT_TEST dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1110: from mtl_material_transactions

1106: , transfer_transaction_id
1107: , transaction_action_id
1108: , shipment_number
1109: , inventory_item_id
1110: from mtl_material_transactions
1111: where organization_id = l_organization_id;
1112:
1113: -- /*
1114: -- ** ---------------------------

Line 1189: l_table_name := 'mtl_material_transactions';

1185: ** Load cursor output into local variables
1186:
1187: */
1188:
1189: l_table_name := 'mtl_material_transactions';
1190:
1191: l_rowid_info :=c1.ROWID;
1192: l_transaction_id := c1.transaction_id;
1193: l_subinventory_code := c1.subinventory_code;

Line 1249: update mtl_material_transactions

1245: end if;
1246:
1247: if (l_cost_group_update = TRUE) and
1248: (l_transfer_cost_group_update = TRUE) then
1249: update mtl_material_transactions
1250: set
1251: cost_group_id = l_cost_group_id
1252: , transfer_cost_group_id = l_transfer_cost_group_id
1253: where transaction_id = l_transaction_id;

Line 1255: update mtl_material_transactions

1251: cost_group_id = l_cost_group_id
1252: , transfer_cost_group_id = l_transfer_cost_group_id
1253: where transaction_id = l_transaction_id;
1254: elsif (l_cost_group_update = TRUE) then
1255: update mtl_material_transactions
1256: set cost_group_id = l_cost_group_id
1257: where transaction_id = l_transaction_id;
1258: elsif (l_transfer_cost_group_update = TRUE) then
1259: update mtl_material_transactions

Line 1259: update mtl_material_transactions

1255: update mtl_material_transactions
1256: set cost_group_id = l_cost_group_id
1257: where transaction_id = l_transaction_id;
1258: elsif (l_transfer_cost_group_update = TRUE) then
1259: update mtl_material_transactions
1260: set transfer_cost_group_id = l_transfer_cost_group_id
1261: where transaction_id = l_transaction_id;
1262: end if;
1263:

Line 1354: l_return_err := 'mtl_material_transactions cost group upgrade:'|| l_msg_data;

1350: );
1351:
1352: l_msg_data := replace(l_msg_data,chr(0),' ');
1353:
1354: l_return_err := 'mtl_material_transactions cost group upgrade:'|| l_msg_data;
1355:
1356:
1357: INS_ERROR( p_table_name => l_table_name,
1358: p_ROWID => l_rowid_info,

Line 1381: l_return_err := 'mtl_material_transactions cost group upgrade:'|| l_msg_data;

1377: );
1378:
1379: l_msg_data := replace(l_msg_data,chr(0),' ');
1380:
1381: l_return_err := 'mtl_material_transactions cost group upgrade:'|| l_msg_data;
1382:
1383:
1384:
1385: INS_ERROR( p_table_name => l_table_name,

Line 1412: l_return_err := 'mtl_material_transactions cost group upgrade:'||

1408: p_ROWID => l_rowid_info,
1409: p_org_id => l_organization_id,
1410: p_error_msg => l_msg_data,
1411: p_proc_name => l_procedure_name);
1412: l_return_err := 'mtl_material_transactions cost group upgrade:'||
1413: substr(sqlerrm,1,55);
1414: raise_application_error(-20000,l_return_err);
1415:
1416: