APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 7642: FROM mtl_system_items_b

7638: l_txn_rec.transaction_date := inv_rec.mtl_txn_date;
7639:
7640: SELECT serial_number_control_code
7641: INTO l_src_serial_code
7642: FROM mtl_system_items_b
7643: WHERE inventory_item_id = inv_rec.item_id
7644: AND organization_id = inv_rec.xfer_organization_id;
7645:
7646: SELECT nvl(mssi.location_id, haou.location_id)

Line 7925: FROM mtl_system_items_b

7921: l_txn_rec.transaction_date := inv_rec.mtl_txn_date;
7922:
7923: SELECT serial_number_control_code
7924: INTO l_src_serial_code
7925: FROM mtl_system_items_b
7926: WHERE inventory_item_id = inv_rec.item_id
7927: AND organization_id = inv_rec.xfer_organization_id;
7928:
7929: SELECT serial_number_control_code

Line 7931: FROM mtl_system_items_b

7927: AND organization_id = inv_rec.xfer_organization_id;
7928:
7929: SELECT serial_number_control_code
7930: INTO l_dest_serial_code
7931: FROM mtl_system_items_b
7932: WHERE inventory_item_id = inv_rec.item_id
7933: AND organization_id = inv_rec.organization_id;
7934:
7935: IF l_src_serial_code in (2, 5, 6) THEN

Line 9626: ,MTL_SYSTEM_ITEMS_B msi

9622: CURSOR CSI_CUR IS
9623: Select instance_id,location_type_code
9624: ,serial_number_control_code,serial_number,null usage_code
9625: from CSI_ITEM_INSTANCES cii
9626: ,MTL_SYSTEM_ITEMS_B msi
9627: Where cii.instance_usage_code is NULL
9628: and msi.inventory_item_id = cii.inventory_item_id
9629: and msi.organization_id = cii.last_vld_organization_id;
9630: --

Line 9970: ,mtl_system_items_b b

9966: ,a.last_oe_order_line_id
9967: ,a.serial_number
9968: ,a.inventory_revision
9969: FROM csi_item_instances a
9970: ,mtl_system_items_b b
9971: WHERE a.inventory_item_id = b.inventory_item_id
9972: AND a.last_vld_organization_id = b.organization_id
9973: AND a.creation_complete_flag = 'Y'
9974: AND a.inventory_revision IS NULL

Line 10324: from MTL_SYSTEM_ITEMS_B

10320: --
10321: Begin
10322: select serial_number_control_code
10323: into v_srl_control
10324: from MTL_SYSTEM_ITEMS_B
10325: where inventory_item_id = i.inventory_item_id
10326: and organization_id = v_org_id;
10327: Exception
10328: when others then

Line 14750: FROM mtl_system_items_b c_msi, -- Child Items

14746: m_msi.comms_nl_trackable_flag,
14747: c_msi.comms_nl_trackable_flag,
14748: m_mp.organization_code,
14749: c_mp.organization_code
14750: FROM mtl_system_items_b c_msi, -- Child Items
14751: mtl_parameters c_mp, -- Child Parameters
14752: mtl_system_items_kfv m_msi, -- Master Items
14753: mtl_parameters m_mp -- Master Parameters
14754: WHERE m_mp.organization_id = m_mp.master_organization_id

Line 14842: mtl_system_items_b c

14838: a.inv_locator_id,
14839: a.lot_number,
14840: a.owner_party_id
14841: FROM csi_item_instances a,
14842: mtl_system_items_b c
14843: WHERE a.ROWID > (SELECT MIN(b.ROWID)
14844: FROM csi_item_instances b
14845: WHERE b.inventory_item_id = a.inventory_item_id
14846: AND b.location_type_code = a.location_type_code

Line 14880: mtl_system_items_b c

14876: a.inv_locator_id,
14877: a.lot_number,
14878: a.owner_party_id
14879: FROM csi_item_instances a,
14880: mtl_system_items_b c
14881: WHERE a.ROWID = (SELECT MIN(b.ROWID)
14882: FROM csi_item_instances b
14883: WHERE b.inventory_item_id = a.inventory_item_id
14884: AND b.location_type_code = a.location_type_code

Line 15148: FROM mtl_system_items_b msi ,

15144: SELECT comms_nl_trackable_flag,
15145: organization_code
15146: INTO l_ib_flag,
15147: l_org_code
15148: FROM mtl_system_items_b msi ,
15149: mtl_parameters mp
15150: WHERE msi.inventory_item_id = csi_rec.inventory_item_id
15151: AND msi.organization_id = mp.master_organization_id
15152: AND mp.organization_id = csi_rec.organization_id;