APPS.INVUPD2B dependencies on MTL_SYSTEM_ITEMS_B

Line 1434: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1430: CURSOR C_msi_child_records is
1431: select
1432: MSI.INVENTORY_ITEM_ID,
1433: MSI.ORGANIZATION_ID
1434: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1435: where MP.master_organization_id = org_id
1436: and MP.organization_id = MSI.organization_id
1437: and MSI.inventory_item_id = inv_item_id
1438: and MSI.organization_id <> MP.master_organization_id;

Line 3506: msi_temp mtl_system_items_b%ROWTYPE;

3502: )
3503: RETURN INTEGER
3504: IS
3505: msii_temp mtl_system_items_interface%ROWTYPE;
3506: msi_temp mtl_system_items_b%ROWTYPE;
3507:
3508: dumm_status NUMBER;
3509: status NUMBER;
3510:

Line 3596: from MTL_SYSTEM_ITEMS_B MSI

3592:
3593: -- msi (updated from)
3594: select *
3595: into msi_temp
3596: from MTL_SYSTEM_ITEMS_B MSI
3597: where MSI.organization_id = msii_temp.organization_id
3598: and msi.inventory_item_id = msii_temp.inventory_item_id ;
3599:
3600: select master_organization_id

Line 5518: FROM mtl_system_items_b_kfv msik,

5514: msii.segment1,msii.segment2,msii.segment3,msii.segment4,msii.segment5,
5515: msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
5516: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5517: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5518: FROM mtl_system_items_b_kfv msik,
5519: mtl_system_items_interface msii,
5520: mtl_parameters mp
5521: WHERE msii.set_process_id = xset_id
5522: AND msii.transaction_type = 'UPDATE'

Line 5693: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii

5689: msi.CONTRACT_ITEM_TYPE_CODE contract_type,
5690: msi.INVENTORY_ASSET_FLAG inv_asset_flag,--Bug:3899614
5691: msi.OBJECT_VERSION_NUMBER obj_ver_num,
5692: msii.ROWID msii_rowid, msii.*
5693: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii
5694: where item_rec.inventory_item_id = msii.inventory_item_id
5695: and item_rec.inventory_item_id = msi.inventory_item_id
5696: and msii.transaction_type in ('UPDATE','AUTO_CHILD')
5697: and msi.organization_id = msii.organization_id

Line 5711: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;

5707: -- 2810346: Lock failed record details into log
5708: l_org_id mtl_system_items_interface.organization_id%TYPE;
5709: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
5710:
5711: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
5712:
5713: BEGIN
5714: SAVEPOINT before_lock; -- Bug 5997870
5715: FOR rec IN C_lock_msi_records LOOP

Line 5894: FROM mtl_system_items_b i

5890: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
5891: )
5892: and EXISTS
5893: ( SELECT 'x'
5894: FROM mtl_system_items_b i
5895: WHERE i.inventory_item_id = rec.inventory_item_id
5896: AND i.organization_id = p.organization_id
5897: )
5898: -- Check if the item already has any category assignment

Line 6001: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI

5997: );
5998:
5999: END IF;
6000:
6001: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI
6002: SET
6003: --* Modified l_sysdate => Nvl(rec.LAST_UPDATE_DATE,l_sysdate) for Bug - 3313863
6004: LAST_UPDATE_DATE = Nvl(rec.LAST_UPDATE_DATE,l_sysdate),
6005: LAST_UPDATED_BY = user_id,

Line 6546: UPDATE mtl_system_items_b

6542: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6543: 'segment1' || item_csr.segment1);
6544: END IF;
6545:
6546: UPDATE mtl_system_items_b
6547: SET segment1 = item_csr.segment1,
6548: segment2 = item_csr.segment2,
6549: segment3 = item_csr.segment3,
6550: segment4 = item_csr.segment4,