eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_DIAGNOSTICS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 3388: FROM mtl_system_items msi,

3384: mmt.transaction_source_id mtl_source_id,
3385: mmt.transaction_type_id mtl_type_id,
3386: mtt.type_class mtl_type_class,
3387: mmt.transaction_quantity mtl_txn_qty
3388: FROM mtl_system_items msi,
3389: mtl_transaction_types mtt,
3390: mtl_material_transactions mmt
3391: WHERE mmt.transaction_source_type_id = 5
3392: AND mmt.transaction_action_id IN (1, 27, 31, 32, 33, 34)

Line 3705: FROM mtl_system_items msi,

3701: msn.current_organization_id organization_id
3702: FROM mtl_serial_numbers msn
3703: WHERE exists (
3704: SELECT '1'
3705: FROM mtl_system_items msi,
3706: mtl_parameters mp
3707: WHERE mp.organization_id = msn.current_organization_id
3708: AND msi.organization_id = mp.master_organization_id
3709: AND msi.inventory_item_id = msn.inventory_item_id

Line 3742: FROM mtl_system_items

3738: SELECT serial_number_control_code,
3739: lot_control_code
3740: INTO l_serial_code,
3741: l_lot_code
3742: FROM mtl_system_items
3743: WHERE inventory_item_id = l_item_id_tab(ind)
3744: AND organization_id = l_organization_id_tab(ind);
3745:
3746: pump_srl_missing_txns(

Line 3860: FROM mtl_system_items

3856: SELECT serial_number_control_code,
3857: lot_control_code
3858: INTO l_serial_code,
3859: l_lot_code
3860: FROM mtl_system_items
3861: WHERE inventory_item_id = l_inv_item_id
3862: AND organization_id = l_inv_org_id;
3863:
3864: FOR srl_rec in srl_cur(l_mtl_txn_id_tab(ind))

Line 3918: FROM mtl_system_items

3914: SELECT serial_number_control_code,
3915: lot_control_code
3916: INTO l_serial_code,
3917: l_lot_code
3918: FROM mtl_system_items
3919: WHERE inventory_item_id = l_inst_item_id
3920: AND organization_id = l_inst_vld_org_id;
3921:
3922: pump_srl_missing_txns(

Line 4131: FROM mtl_system_items

4127: SELECT serial_number_control_code,
4128: lot_control_code
4129: INTO l_err_txn_serial_code,
4130: l_err_txn_lot_code
4131: FROM mtl_system_items
4132: WHERE inventory_item_id = l_inv_item_id
4133: AND organization_id = l_inv_org_id;
4134:
4135: l_unit_txn_found := FALSE;

Line 4345: FROM mtl_system_items

4341: revision_qty_control_code
4342: INTO l_serial_code,
4343: l_lot_code,
4344: l_revision_code
4345: FROM mtl_system_items
4346: WHERE inventory_item_id = txn_rec.item_id
4347: AND organization_id = txn_rec.organization_id;
4348:
4349: get_source_type(

Line 6136: FROM mtl_system_items

6132: END IF;
6133:
6134: SELECT primary_uom_code
6135: INTO l_instance_rec.unit_of_measure
6136: FROM mtl_system_items
6137: WHERE inventory_item_id = l_instance_rec.inventory_item_id
6138: AND organization_id = l_instance_rec.vld_organization_id;
6139:
6140: csi_item_instance_pub.create_item_instance(

Line 6607: FROM mtl_system_items

6603: SELECT lot_control_code,
6604: primary_uom_code
6605: INTO l_lot_code,
6606: l_uom_code
6607: FROM mtl_system_items
6608: WHERE inventory_item_id = txn_rec.inventory_item_id
6609: AND organization_id = txn_rec.organization_id;
6610:
6611: FOR stage_rec IN stage_cur (txn_rec.mtl_txn_id, l_lot_code)

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 8216: FROM mtl_system_items

8212: primary_uom_code
8213: INTO l_src_serial_code,
8214: l_src_lot_code,
8215: l_primary_uom_code
8216: FROM mtl_system_items
8217: WHERE inventory_item_id = inv_rec.item_id
8218: AND organization_id = inv_rec.organization_id;
8219:
8220: SELECT serial_number_control_code,

Line 8224: FROM mtl_system_items

8220: SELECT serial_number_control_code,
8221: lot_control_code
8222: INTO l_dest_serial_code,
8223: l_dest_lot_code
8224: FROM mtl_system_items
8225: WHERE inventory_item_id = inv_rec.item_id
8226: AND organization_id = inv_rec.xfer_organization_id;
8227:
8228: l_txn_rec.transaction_id := fnd_api.g_miss_num;

Line 8850: FROM mtl_system_items msi,

8846: msn.lot_number lot_number,
8847: msi.primary_uom_code uom_code,
8848: msi.serial_number_control_code serial_code,
8849: msi.lot_control_code lot_code
8850: FROM mtl_system_items msi,
8851: mtl_serial_numbers msn
8852: WHERE msi.inventory_item_id = msn.inventory_item_id
8853: AND msi.organization_id = msn.current_organization_id
8854: AND msi.serial_number_control_code in (2,5)

Line 8859: mtl_system_items msi_mast

8855: AND msn.current_status = 3
8856: AND EXISTS (
8857: SELECT '1'
8858: FROM mtl_parameters mp,
8859: mtl_system_items msi_mast
8860: WHERE mp.organization_id = msi.organization_id
8861: AND msi_mast.inventory_item_id = msi.inventory_item_id
8862: AND msi_mast.organization_id = mp.master_organization_id
8863: AND nvl(msi_mast.comms_nl_trackable_flag,'N') = 'Y')

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 11337: from MTL_SYSTEM_ITEMS

11333: Begin
11334: Begin
11335: select nvl(comms_nl_trackable_flag,'N')
11336: into l_nl
11337: from MTL_SYSTEM_ITEMS
11338: where inventory_item_id = inventory_item_id_mig(j)
11339: and organization_id = mast_org_id_mig(j);
11340: Exception
11341: when no_data_found then

Line 11390: from MTL_SYSTEM_ITEMS

11386: Begin
11387: Begin
11388: select nvl(comms_nl_trackable_flag,'N')
11389: into l_nl
11390: from MTL_SYSTEM_ITEMS
11391: where inventory_item_id = inventory_item_id_mig(i)
11392: and organization_id = mast_org_id_mig(i);
11393: Exception
11394: when no_data_found then

Line 11560: from MTL_SYSTEM_ITEMS msi,

11556: --
11557: FOR i in 1 .. txn_error_id_mig.count LOOP
11558: select comms_nl_trackable_flag
11559: into l_nl
11560: from MTL_SYSTEM_ITEMS msi,
11561: MTL_PARAMETERS mp
11562: where mp.organization_id = organization_id_mig(i)
11563: and msi.inventory_item_id = inventory_item_id_mig(i)
11564: and msi.organization_id = mp.master_organization_id;

Line 11616: from MTL_SYSTEM_ITEMS msi,

11612: --
11613: Begin
11614: select comms_nl_trackable_flag
11615: into l_nl
11616: from MTL_SYSTEM_ITEMS msi,
11617: MTL_PARAMETERS mp
11618: where mp.organization_id = l_organization_id
11619: and msi.inventory_item_id = l_item_id
11620: and msi.organization_id = mp.master_organization_id;

Line 11792: from MTL_SYSTEM_ITEMS

11788: v_srl_ctl := null;
11789: Begin
11790: select serial_number_control_code
11791: into v_srl_ctl
11792: from MTL_SYSTEM_ITEMS
11793: where inventory_item_id = inventory_item_id_mig(i)
11794: and organization_id = vld_org_id_mig(i);
11795: Exception
11796: when others then

Line 11876: from MTL_SYSTEM_ITEMS

11872: v_lot_ctl := null;
11873: Begin
11874: select lot_control_code
11875: into v_lot_ctl
11876: from MTL_SYSTEM_ITEMS
11877: where inventory_item_id = inventory_item_id_mig(i)
11878: and organization_id = vld_org_id_mig(i);
11879: Exception
11880: when others then

Line 11958: from MTL_SYSTEM_ITEMS

11954: v_srl_ctl := null;
11955: Begin
11956: select serial_number_control_code
11957: into v_srl_ctl
11958: from MTL_SYSTEM_ITEMS
11959: where inventory_item_id = inventory_item_id_mig(i)
11960: and organization_id = vld_org_id_mig(i);
11961: Exception
11962: when others then

Line 12036: from MTL_SYSTEM_ITEMS

12032: v_lot_ctl := null;
12033: Begin
12034: select lot_control_code
12035: into v_lot_ctl
12036: from MTL_SYSTEM_ITEMS
12037: where inventory_item_id = inventory_item_id_mig(i)
12038: and organization_id = vld_org_id_mig(i);
12039: Exception
12040: when others then

Line 12309: from MTL_SYSTEM_ITEMS

12305: End;
12306: Begin
12307: select primary_uom_code,serial_number_control_code,lot_control_code
12308: into v_pri_uom,v_srl_ctl,v_lot_ctl
12309: from MTL_SYSTEM_ITEMS
12310: where inventory_item_id = inventory_item_id_mig(i)
12311: and organization_id = organization_id_mig(i);
12312: Exception
12313: when no_data_found then

Line 12336: from MTL_SYSTEM_ITEMS

12332: v_nl_trackable := 'N';
12333: Begin
12334: select comms_nl_trackable_flag
12335: into v_nl_trackable
12336: from MTL_SYSTEM_ITEMS
12337: where inventory_item_id = inventory_item_id_mig(i)
12338: and organization_id = v_mast_org_id;
12339: Exception
12340: when no_data_found then

Line 13392: mtl_system_items msi

13388: msn.inventory_item_id,
13389: msn.current_organization_id,
13390: msi.lot_control_code
13391: FROM mtl_serial_numbers msn,
13392: mtl_system_items msi
13393: WHERE msn.current_status = 1 -- predefined state (for rma'ed serials)
13394: AND msi.inventory_item_id = msn.inventory_item_id
13395: AND msi.organization_id = msn.current_organization_id
13396: AND msi.serial_number_control_code = 6 -- serialized at so issue

Line 13589: mtl_system_items msi

13585: , moq.lot_number lot_number
13586: , msi.primary_uom_code primary_uom_code
13587: , sum(moq.transaction_quantity) onhand_qty
13588: from
13589: mtl_system_items msi
13590: , mtl_onhand_quantities moq
13591: where msi.inventory_item_id = moq.inventory_item_id
13592: and msi.organization_id = moq.organization_id
13593: and msi.serial_number_control_code in (1,6) -- No Serial control and at SO Issue Items

Line 13749: from MTL_SYSTEM_ITEMS

13745: v_nl_trackable := 'N';
13746: Begin
13747: select comms_nl_trackable_flag
13748: into v_nl_trackable
13749: from MTL_SYSTEM_ITEMS
13750: where inventory_item_id = inventory_item_id_mig(i)
13751: and organization_id = v_mast_org_id;
13752: Exception
13753: when no_data_found then

Line 14486: FROM mtl_system_items

14482: SELECT serial_number_control_code,
14483: lot_control_code
14484: INTO v_srl_ctl,
14485: v_lot_ctl
14486: FROM mtl_system_items
14487: WHERE inventory_item_id = item_id(i)
14488: AND organization_id = inv_org_id(i);
14489: EXCEPTION
14490: WHEN no_data_found THEN

Line 14551: MTL_SYSTEM_ITEMS msi

14547: select cii.instance_id,cii.inventory_item_id,cii.inv_organization_id,
14548: cii.inv_subinventory_name,cii.inv_locator_id,
14549: cii.inventory_revision,cii.lot_number,cii.quantity
14550: from CSI_ITEM_INSTANCES cii,
14551: MTL_SYSTEM_ITEMS msi
14552: where cii.location_type_code = 'INVENTORY'
14553: and cii.instance_usage_code = 'IN_INVENTORY'
14554: and cii.serial_number is NULL
14555: and msi.inventory_item_id = cii.inventory_item_id

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 14752: mtl_system_items_kfv m_msi, -- Master Items

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
14755: AND m_msi.organization_id = m_mp.organization_id
14756: AND m_msi.organization_id = c_mp.master_organization_id

Line 14782: Type V240TabType is VARRAY(10000) of MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

14778: l_child_flag_mig V1TabType;
14779: Type V3TabType is VARRAY(10000) of VARCHAR2(3);
14780: l_master_org_mig V3TabType;
14781: l_child_org_mig V3TabType;
14782: Type V240TabType is VARRAY(10000) of MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
14783: l_item_segment_mig V240TabType;
14784: --
14785: MAX_BUFFER_SIZE NUMBER := 1000;
14786: BEGIN

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 15140: FROM mtl_system_items_kfv mtl

15136: SELECT concatenated_segments,
15137: serial_number_control_code,
15138: lot_control_code
15139: INTO l_item, l_srl_ctl,l_lot_ctl
15140: FROM mtl_system_items_kfv mtl
15141: WHERE mtl.inventory_item_id = csi_rec.inventory_item_id
15142: AND mtl.organization_id = csi_rec.organization_id;
15143:
15144: SELECT comms_nl_trackable_flag,

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;

Line 15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca

15393: oel.sold_to_org_id owner_acct,
15394: oel.ordered_quantity ordered_qty,
15395: oel.order_quantity_uom ordered_uom,
15396: hca.party_id party_id
15397: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15398: WHERE cte.processed_flag in ('E', 'R')
15399: AND cte.transaction_type_id = 53
15400: AND cte.inv_material_transaction_id = mmt.transaction_id
15401: AND msi.inventory_item_id = mmt.inventory_item_id

Line 15754: SELECT 'X' FROM mtl_system_items msi

15750: FROM csi_item_instances cii
15751: WHERE cii.location_type_code = 'WIP'
15752: AND cii.instance_usage_code <> 'IN_RELATIONSHIP'
15753: AND exists (
15754: SELECT 'X' FROM mtl_system_items msi
15755: WHERE msi.inventory_item_id = cii.inventory_item_id
15756: AND msi.organization_id = cii.last_vld_organization_id
15757: AND msi.serial_number_control_code in (1, 6));
15758:

Line 15805: mtl_system_items msi

15801: cii.inventory_revision,
15802: cii.lot_number,
15803: cii.wip_job_id
15804: FROM csi_item_instances cii,
15805: mtl_system_items msi
15806: WHERE cii.location_type_code = 'WIP'
15807: AND cii.instance_usage_code = 'IN_WIP'
15808: AND msi.inventory_item_id = cii.inventory_item_id
15809: AND msi.organization_id = cii.last_vld_organization_id

Line 16392: FROM MTL_SYSTEM_ITEMS msi,

16388: BEGIN
16389: BEGIN
16390: SELECT comms_nl_trackable_flag
16391: INTO v_nl_trackable
16392: FROM MTL_SYSTEM_ITEMS msi,
16393: MTL_PARAMETERS mp
16394: where mp.organization_id = :new.organization_id
16395: and msi.inventory_item_id = :new.inventory_item_id
16396: and msi.organization_id = mp.master_organization_id;