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 14739: FROM mtl_system_items_b c_msi, -- Child Items

14735: m_msi.comms_nl_trackable_flag,
14736: c_msi.comms_nl_trackable_flag,
14737: m_mp.organization_code,
14738: c_mp.organization_code
14739: FROM mtl_system_items_b c_msi, -- Child Items
14740: mtl_parameters c_mp, -- Child Parameters
14741: mtl_system_items_kfv m_msi, -- Master Items
14742: mtl_parameters m_mp -- Master Parameters
14743: WHERE m_mp.organization_id = m_mp.master_organization_id

Line 14831: mtl_system_items_b c

14827: a.inv_locator_id,
14828: a.lot_number,
14829: a.owner_party_id
14830: FROM csi_item_instances a,
14831: mtl_system_items_b c
14832: WHERE a.ROWID > (SELECT MIN(b.ROWID)
14833: FROM csi_item_instances b
14834: WHERE b.inventory_item_id = a.inventory_item_id
14835: AND b.location_type_code = a.location_type_code

Line 14869: mtl_system_items_b c

14865: a.inv_locator_id,
14866: a.lot_number,
14867: a.owner_party_id
14868: FROM csi_item_instances a,
14869: mtl_system_items_b c
14870: WHERE a.ROWID = (SELECT MIN(b.ROWID)
14871: FROM csi_item_instances b
14872: WHERE b.inventory_item_id = a.inventory_item_id
14873: AND b.location_type_code = a.location_type_code

Line 15137: FROM mtl_system_items_b msi ,

15133: SELECT comms_nl_trackable_flag,
15134: organization_code
15135: INTO l_ib_flag,
15136: l_org_code
15137: FROM mtl_system_items_b msi ,
15138: mtl_parameters mp
15139: WHERE msi.inventory_item_id = csi_rec.inventory_item_id
15140: AND msi.organization_id = mp.master_organization_id
15141: AND mp.organization_id = csi_rec.organization_id;