APPS.INV_CG_UPGRADE dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1360: from mtl_material_transactions

1356: , transfer_transaction_id
1357: , transaction_action_id
1358: , shipment_number
1359: , inventory_item_id
1360: from mtl_material_transactions
1361: where organization_id = l_organization_id
1362: and transaction_date >= l_s_date
1363: and transaction_date <= l_e_date
1364: and transaction_action_id <> 30;

Line 1386: from mtl_material_transactions

1382: , transfer_transaction_id
1383: , transaction_action_id
1384: , shipment_number
1385: , inventory_item_id
1386: from mtl_material_transactions
1387: where organization_id = l_organization_id
1388: and transaction_action_id <> 30;
1389: --end5073454
1390:

Line 1478: FROM mtl_material_transactions

1474: select 1
1475: into l_dummy
1476: from dual
1477: where exists (SELECT cost_group_id
1478: FROM mtl_material_transactions
1479: WHERE organization_id = l_organization_id
1480: and cost_group_id is not null
1481: and transaction_date >= l_s_date
1482: and transaction_date <= l_e_date

Line 1500: FROM mtl_material_transactions

1496: select 1
1497: into l_dummy
1498: from dual
1499: where exists (SELECT cost_group_id
1500: FROM mtl_material_transactions
1501: WHERE organization_id = l_organization_id
1502: and cost_group_id is not null
1503: and transaction_action_id <> 30);
1504: exception

Line 1550: l_table_name := 'mtl_material_transactions';

1546: ** Load cursor output into local variables
1547:
1548: */
1549:
1550: l_table_name := 'mtl_material_transactions';
1551:
1552: l_rowid_info :=c1.ROWID;
1553: l_transaction_id := c1.transaction_id;
1554: l_subinventory_code := c1.subinventory_code;

Line 1664: update mtl_material_transactions

1660:
1661:
1662: if (l_cost_group_update = TRUE) and
1663: (l_transfer_cost_group_update = TRUE) then
1664: update mtl_material_transactions
1665: set
1666: cost_group_id = l_cost_group_id
1667: , transfer_cost_group_id = l_transfer_cost_group_id
1668: where transaction_id = l_transaction_id;

Line 1670: update mtl_material_transactions

1666: cost_group_id = l_cost_group_id
1667: , transfer_cost_group_id = l_transfer_cost_group_id
1668: where transaction_id = l_transaction_id;
1669: elsif (l_cost_group_update = TRUE) then
1670: update mtl_material_transactions
1671: set cost_group_id = l_cost_group_id
1672: where transaction_id = l_transaction_id;
1673: elsif (l_transfer_cost_group_update = TRUE) then
1674: update mtl_material_transactions

Line 1674: update mtl_material_transactions

1670: update mtl_material_transactions
1671: set cost_group_id = l_cost_group_id
1672: where transaction_id = l_transaction_id;
1673: elsif (l_transfer_cost_group_update = TRUE) then
1674: update mtl_material_transactions
1675: set transfer_cost_group_id = l_transfer_cost_group_id
1676: where transaction_id = l_transaction_id;
1677: end if;
1678:

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

1774: );
1775:
1776: l_msg_data := replace(l_msg_data,chr(0),' ');
1777:
1778: l_return_err := 'mtl_material_transactions cost group upgrade:'|| l_msg_data;
1779:
1780:
1781: INS_ERROR( p_table_name => l_table_name,
1782: p_ROWID => l_rowid_info,

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

1801: );
1802:
1803: l_msg_data := replace(l_msg_data,chr(0),' ');
1804:
1805: l_return_err := 'mtl_material_transactions cost group upgrade:'|| l_msg_data;
1806:
1807:
1808:
1809: INS_ERROR( p_table_name => l_table_name,

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

1832: p_ROWID => l_rowid_info,
1833: p_org_id => l_organization_id,
1834: p_error_msg => l_msg_data,
1835: p_proc_name => l_procedure_name);
1836: l_return_err := 'mtl_material_transactions cost group upgrade:'||
1837: substr(sqlerrm,1,55);
1838: raise_application_error(-20000,l_return_err);
1839:
1840: