APPS.INVUPD2B dependencies on MTL_SYSTEM_ITEMS_B

Line 1465: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1461: CURSOR C_msi_child_records is
1462: select
1463: MSI.INVENTORY_ITEM_ID,
1464: MSI.ORGANIZATION_ID
1465: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1466: where MP.master_organization_id = org_id
1467: and MP.organization_id = MSI.organization_id
1468: and MSI.inventory_item_id = inv_item_id
1469: and MSI.organization_id <> MP.master_organization_id;

Line 3559: msi_temp mtl_system_items_b%ROWTYPE;

3555: )
3556: RETURN INTEGER
3557: IS
3558: msii_temp mtl_system_items_interface%ROWTYPE;
3559: msi_temp mtl_system_items_b%ROWTYPE;
3560:
3561: dumm_status NUMBER;
3562: status NUMBER;
3563:

Line 3653: from MTL_SYSTEM_ITEMS_B MSI

3649:
3650: -- msi (updated from)
3651: select *
3652: into msi_temp
3653: from MTL_SYSTEM_ITEMS_B MSI
3654: where MSI.organization_id = msii_temp.organization_id
3655: and msi.inventory_item_id = msii_temp.inventory_item_id ;
3656:
3657: select master_organization_id

Line 5764: FROM mtl_system_items_b_kfv msik,

5760: msii.segment1,msii.segment2,msii.segment3,msii.segment4,msii.segment5,
5761: msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
5762: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5763: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5764: FROM mtl_system_items_b_kfv msik,
5765: mtl_system_items_interface msii,
5766: mtl_parameters mp
5767: WHERE msii.set_process_id = xset_id
5768: AND msii.transaction_type = 'UPDATE'

Line 6007: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii

6003: msi.CONTRACT_ITEM_TYPE_CODE contract_type,
6004: msi.INVENTORY_ASSET_FLAG inv_asset_flag,--Bug:3899614
6005: msi.OBJECT_VERSION_NUMBER obj_ver_num,
6006: msii.ROWID msii_rowid, msii.*
6007: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii
6008: where item_rec.inventory_item_id = msii.inventory_item_id
6009: and item_rec.inventory_item_id = msi.inventory_item_id
6010: and msii.transaction_type in ('UPDATE','AUTO_CHILD')
6011: and msi.organization_id = msii.organization_id

Line 6025: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;

6021: -- 2810346: Lock failed record details into log
6022: l_org_id mtl_system_items_interface.organization_id%TYPE;
6023: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
6024:
6025: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
6026:
6027: BEGIN
6028: SAVEPOINT before_lock; -- Bug 5997870
6029: FOR rec IN C_lock_msi_records LOOP

Line 6223: FROM mtl_system_items_b i

6219: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
6220: )
6221: and EXISTS
6222: ( SELECT 'x'
6223: FROM mtl_system_items_b i
6224: WHERE i.inventory_item_id = rec.inventory_item_id
6225: AND i.organization_id = mp.organization_id
6226: )
6227: -- Check if the item already has any category assignment

Line 6294: FROM mtl_system_items_b i

6290: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
6291: )
6292: and EXISTS
6293: ( SELECT 'x'
6294: FROM mtl_system_items_b i
6295: WHERE i.inventory_item_id = rec.inventory_item_id
6296: AND i.organization_id = rec.organization_id
6297: )
6298: -- Check if the item already has any category assignment

Line 6429: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI

6425: END IF;
6426:
6427: -- bug 10373720 , set last_update_date = sysdate
6428: -- old Modified l_sysdate => Nvl(rec.LAST_UPDATE_DATE,l_sysdate) for Bug - 3313863
6429: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI
6430: SET
6431: LAST_UPDATE_DATE = l_sysdate,
6432: LAST_UPDATED_BY = user_id,
6433: LAST_UPDATE_LOGIN = login_id,

Line 6980: UPDATE mtl_system_items_b

6976: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6977: 'segment1' || item_csr.segment1);
6978: END IF;
6979:
6980: UPDATE mtl_system_items_b
6981: SET segment1 = item_csr.segment1,
6982: segment2 = item_csr.segment2,
6983: segment3 = item_csr.segment3,
6984: segment4 = item_csr.segment4,