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

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

Line 11875: from MTL_SYSTEM_ITEMS

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

Line 11957: from MTL_SYSTEM_ITEMS

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

Line 12034: from MTL_SYSTEM_ITEMS

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

Line 12304: from MTL_SYSTEM_ITEMS

12300: End;
12301: Begin
12302: select primary_uom_code,serial_number_control_code,lot_control_code
12303: into v_pri_uom,v_srl_ctl,v_lot_ctl
12304: from MTL_SYSTEM_ITEMS
12305: where inventory_item_id = inventory_item_id_mig(i)
12306: and organization_id = organization_id_mig(i);
12307: Exception
12308: when no_data_found then

Line 12331: from MTL_SYSTEM_ITEMS

12327: v_nl_trackable := 'N';
12328: Begin
12329: select comms_nl_trackable_flag
12330: into v_nl_trackable
12331: from MTL_SYSTEM_ITEMS
12332: where inventory_item_id = inventory_item_id_mig(i)
12333: and organization_id = v_mast_org_id;
12334: Exception
12335: when no_data_found then

Line 13387: mtl_system_items msi

13383: msn.inventory_item_id,
13384: msn.current_organization_id,
13385: msi.lot_control_code
13386: FROM mtl_serial_numbers msn,
13387: mtl_system_items msi
13388: WHERE msn.current_status = 1 -- predefined state (for rma'ed serials)
13389: AND msi.inventory_item_id = msn.inventory_item_id
13390: AND msi.organization_id = msn.current_organization_id
13391: AND msi.serial_number_control_code = 6 -- serialized at so issue

Line 13584: mtl_system_items msi

13580: , moq.lot_number lot_number
13581: , msi.primary_uom_code primary_uom_code
13582: , sum(moq.transaction_quantity) onhand_qty
13583: from
13584: mtl_system_items msi
13585: , mtl_onhand_quantities moq
13586: where msi.inventory_item_id = moq.inventory_item_id
13587: and msi.organization_id = moq.organization_id
13588: and msi.serial_number_control_code in (1,6) -- No Serial control and at SO Issue Items

Line 13744: from MTL_SYSTEM_ITEMS

13740: v_nl_trackable := 'N';
13741: Begin
13742: select comms_nl_trackable_flag
13743: into v_nl_trackable
13744: from MTL_SYSTEM_ITEMS
13745: where inventory_item_id = inventory_item_id_mig(i)
13746: and organization_id = v_mast_org_id;
13747: Exception
13748: when no_data_found then

Line 14481: FROM mtl_system_items

14477: SELECT serial_number_control_code,
14478: lot_control_code
14479: INTO v_srl_ctl,
14480: v_lot_ctl
14481: FROM mtl_system_items
14482: WHERE inventory_item_id = item_id(i)
14483: AND organization_id = inv_org_id(i);
14484: EXCEPTION
14485: WHEN no_data_found THEN

Line 14546: MTL_SYSTEM_ITEMS msi

14542: select cii.instance_id,cii.inventory_item_id,cii.inv_organization_id,
14543: cii.inv_subinventory_name,cii.inv_locator_id,
14544: cii.inventory_revision,cii.lot_number,cii.quantity
14545: from CSI_ITEM_INSTANCES cii,
14546: MTL_SYSTEM_ITEMS msi
14547: where cii.location_type_code = 'INVENTORY'
14548: and cii.instance_usage_code = 'IN_INVENTORY'
14549: and cii.serial_number is NULL
14550: and msi.inventory_item_id = cii.inventory_item_id

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

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

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

14767: l_child_flag_mig V1TabType;
14768: Type V3TabType is VARRAY(10000) of VARCHAR2(3);
14769: l_master_org_mig V3TabType;
14770: l_child_org_mig V3TabType;
14771: Type V240TabType is VARRAY(10000) of MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
14772: l_item_segment_mig V240TabType;
14773: --
14774: MAX_BUFFER_SIZE NUMBER := 1000;
14775: BEGIN

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

15125: SELECT concatenated_segments,
15126: serial_number_control_code,
15127: lot_control_code
15128: INTO l_item, l_srl_ctl,l_lot_ctl
15129: FROM mtl_system_items_kfv mtl
15130: WHERE mtl.inventory_item_id = csi_rec.inventory_item_id
15131: AND mtl.organization_id = csi_rec.organization_id;
15132:
15133: SELECT comms_nl_trackable_flag,

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;

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

15382: oel.sold_to_org_id owner_acct,
15383: oel.ordered_quantity ordered_qty,
15384: oel.order_quantity_uom ordered_uom,
15385: hca.party_id party_id
15386: FROM csi_txn_errors cte,mtl_material_transactions mmt,mtl_system_items msi,oe_order_lines_all oel,hz_cust_accounts hca
15387: WHERE cte.processed_flag in ('E', 'R')
15388: AND cte.transaction_type_id = 53
15389: AND cte.inv_material_transaction_id = mmt.transaction_id
15390: AND msi.inventory_item_id = mmt.inventory_item_id

Line 15743: SELECT 'X' FROM mtl_system_items msi

15739: FROM csi_item_instances cii
15740: WHERE cii.location_type_code = 'WIP'
15741: AND cii.instance_usage_code <> 'IN_RELATIONSHIP'
15742: AND exists (
15743: SELECT 'X' FROM mtl_system_items msi
15744: WHERE msi.inventory_item_id = cii.inventory_item_id
15745: AND msi.organization_id = cii.last_vld_organization_id
15746: AND msi.serial_number_control_code in (1, 6));
15747:

Line 15794: mtl_system_items msi

15790: cii.inventory_revision,
15791: cii.lot_number,
15792: cii.wip_job_id
15793: FROM csi_item_instances cii,
15794: mtl_system_items msi
15795: WHERE cii.location_type_code = 'WIP'
15796: AND cii.instance_usage_code = 'IN_WIP'
15797: AND msi.inventory_item_id = cii.inventory_item_id
15798: AND msi.organization_id = cii.last_vld_organization_id

Line 16381: FROM MTL_SYSTEM_ITEMS msi,

16377: BEGIN
16378: BEGIN
16379: SELECT comms_nl_trackable_flag
16380: INTO v_nl_trackable
16381: FROM MTL_SYSTEM_ITEMS msi,
16382: MTL_PARAMETERS mp
16383: where mp.organization_id = :new.organization_id
16384: and msi.inventory_item_id = :new.inventory_item_id
16385: and msi.organization_id = mp.master_organization_id;