DBA Data[Home] [Help]

APPS.INV_CG_UPGRADE dependencies on MTL_SUPPLY

Line 1406: from mtl_supply ms,

1402: is
1403: select
1404: ms.rowid
1405: , ms.intransit_owning_org_id
1406: from mtl_supply ms,
1407: rcv_shipment_headers rsh
1408: where rsh.shipment_num = l_shipment_number
1409: and ms.shipment_header_id = rsh.shipment_header_id
1410: and ms.supply_type_code = 'SHIPMENT'

Line 1681: ** corresponding record in MTL_SUPPLY too

1677: end if;
1678:
1679: /*
1680: ** If intransit shipment(action_id =21), we have to update
1681: ** corresponding record in MTL_SUPPLY too
1682: */
1683:
1684: if (l_transaction_action_id = 21) and
1685: (l_shipment_number is not null) and ( p_cost_method <> 1) THEN

Line 1734: update mtl_supply

1730: , p_organization_id => l_intransit_owning_org_id);
1731: end if;
1732:
1733: if (l_ms_cost_group_id > 0) then
1734: update mtl_supply
1735: set cost_group_id = l_ms_cost_group_id
1736: where rowid = l_ms_rowid;
1737: end if;
1738: end loop;