DBA Data[Home] [Help]

APPS.CONVERT_TEST dependencies on MTL_SUPPLY

Line 1126: from mtl_supply ms,

1122: is
1123: select
1124: ms.rowid
1125: , ms.intransit_owning_org_id
1126: from mtl_supply ms,
1127: rcv_shipment_headers rsh
1128: where rsh.shipment_num = l_shipment_number
1129: and ms.shipment_header_id = rsh.shipment_header_id
1130: and ms.supply_type_code = 'SHIPMENT'

Line 1266: ** corresponding record in MTL_SUPPLY too

1262: end if;
1263:
1264: /*
1265: ** If intransit shipment(action_id =21), we have to update
1266: ** corresponding record in MTL_SUPPLY too
1267: */
1268:
1269: if (l_transaction_action_id = 21) and
1270: (l_shipment_number is not null) THEN

Line 1306: update mtl_supply

1302: , p_organization_id => l_intransit_owning_org_id);
1303: end if;
1304:
1305: if (l_ms_cost_group_id > 0) then
1306: update mtl_supply
1307: set cost_group_id = l_ms_cost_group_id
1308: where rowid = l_ms_rowid;
1309: end if;
1310: end loop;