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_ITEM_INSTANCE_VLD_PVT dependencies on MTL_SYSTEM_ITEMS

Line 256: FROM mtl_system_items

252: BEGIN
253:
254: SELECT NVL(comms_nl_trackable_flag,'N') ,NVL(description,' ')
255: INTO l_temp_string,l_description
256: FROM mtl_system_items
257: WHERE inventory_item_id = p_inv_item_id
258: AND organization_id = p_org_id
259: AND enabled_flag = 'Y'
260: AND nvl (start_date_active, sysdate) <= sysdate

Line 402: FROM mtl_system_items

398: l_stack_err_msg BOOLEAN DEFAULT TRUE;
399:
400: CURSOR c1 is
401: SELECT revision_qty_control_code
402: FROM mtl_system_items
403: WHERE inventory_item_id = p_inv_item_id
404: AND organization_id = p_inv_org_id
405: AND enabled_flag = 'Y'
406: AND nvl (start_date_active, sysdate) <= sysdate

Line 508: FROM mtl_system_items

504: l_stack_err_msg BOOLEAN DEFAULT TRUE;
505:
506: CURSOR c1 is
507: SELECT revision_qty_control_code
508: FROM mtl_system_items
509: WHERE inventory_item_id = p_inv_item_id
510: AND organization_id = p_inv_org_id
511: AND enabled_flag = 'Y'
512: AND nvl (start_date_active, sysdate) <= sysdate

Line 669: from MTL_SYSTEM_ITEMS_B

665: l_cst_grp_id NUMBER;
666: --
667: CURSOR CTO_CUR(p_base_model IN NUMBER) IS
668: select distinct inventory_item_id
669: from MTL_SYSTEM_ITEMS_B
670: where base_item_id = p_base_model
671: and inventory_item_id <> p_inv_item_id;
672: --
673: process_next EXCEPTION;

Line 871: from MTL_SYSTEM_ITEMS_B

867: l_base_item_id := NULL;
868: Begin
869: select base_item_id
870: into l_base_item_id
871: from MTL_SYSTEM_ITEMS_B
872: where inventory_item_id = p_inv_item_id
873: and organization_id = p_inv_org_id;
874: Exception
875: when others then

Line 1112: FROM mtl_system_items

1108: -- NULL.
1109:
1110: CURSOR C1 is
1111: SELECT serial_number_control_code
1112: FROM mtl_system_items
1113: WHERE inventory_item_id = p_inv_item_id
1114: AND organization_id = p_inv_org_id
1115: AND enabled_flag = 'Y'
1116: AND nvl (start_date_active, sysdate) <= sysdate

Line 1272: from MTL_SYSTEM_ITEMS_B

1268: l_error_message VARCHAR2(4000);
1269: --
1270: /* CURSOR CTO_CUR(p_base_model IN NUMBER) IS
1271: select distinct inventory_item_id
1272: from MTL_SYSTEM_ITEMS_B
1273: where base_item_id = p_base_model
1274: and inventory_item_id <> p_inv_item_id;
1275: --
1276: */--Commented for bug 12952143

Line 1333: from MTL_SYSTEM_ITEMS_B

1329: IF l_serial_type = 1
1330: THEN
1331: select base_item_id
1332: into l_base_item_id
1333: from MTL_SYSTEM_ITEMS_B
1334: where inventory_item_id = p_inv_item_id
1335: and organization_id = p_inv_org_id;
1336:
1337: CSI_INV_TRXS_PKG.get_master_organization(p_inv_org_id, --added call for 12942740

Line 1354: from MTL_SYSTEM_ITEMS_B

1350: where serial_number = p_serial_number
1351: and inventory_item_id in
1352: (
1353: select inventory_item_id
1354: from MTL_SYSTEM_ITEMS_B
1355: where base_item_id = l_base_item_id
1356: and inventory_item_id <> p_inv_item_id
1357: and organization_id = l_master_organization_id
1358: );

Line 1701: FROM mtl_system_items

1697: --
1698: CURSOR c1 is
1699: SELECT nvl(csi_utl_pkg.get_lot_ctrl_code(p_txn_rec.inv_material_transaction_id),lot_control_code) lot_control_code -- Added for bug#14835893
1700: -- lot_control_code
1701: FROM mtl_system_items
1702: WHERE inventory_item_id = p_inv_item_id
1703: AND organization_id = p_inv_org_id
1704: AND enabled_flag = 'Y'
1705: AND nvl (start_date_active, sysdate) <= sysdate

Line 1996: -- check for the existance of primary uom code in mtl_system_items for the unit of measure code passed

1992: (p_uom_code => p_uom_code ,
1993: p_item_id => p_inv_item_id ,
1994: p_organization_id => p_inv_org_id) ) THEN
1995:
1996: -- check for the existance of primary uom code in mtl_system_items for the unit of measure code passed
1997: BEGIN
1998: SELECT primary_uom_code
1999: INTO to_unit
2000: FROM mtl_system_items

Line 2000: FROM mtl_system_items

1996: -- check for the existance of primary uom code in mtl_system_items for the unit of measure code passed
1997: BEGIN
1998: SELECT primary_uom_code
1999: INTO to_unit
2000: FROM mtl_system_items
2001: WHERE inventory_item_id = p_inv_item_id
2002: AND organization_id = p_inv_org_id
2003: AND enabled_flag = 'Y'
2004: AND nvl (start_date_active, sysdate) <= sysdate

Line 2491: from mtl_system_items

2487: l_return_value := TRUE;
2488: Else
2489: select serial_number_control_code
2490: into l_serial_code
2491: from mtl_system_items
2492: where inventory_item_id = p_instance_rec.inventory_item_id
2493: and organization_id = p_instance_rec.vld_organization_id;
2494: l_return_value := TRUE;
2495: End if;

Line 3425: FROM mtl_system_items

3421: -- value. If it is not under serial_control, then serial number MUST be NULL
3422: --
3423: CURSOR c1 is
3424: SELECT serial_number_control_code
3425: FROM mtl_system_items
3426: WHERE inventory_item_id = p_inv_item_id
3427: AND organization_id = p_inv_org_id
3428: AND enabled_flag = 'Y'
3429: AND nvl (start_date_active, sysdate) <= sysdate

Line 4058: FROM mtl_system_items

4054:
4055:
4056: SELECT '1'
4057: INTO l_dummy
4058: FROM mtl_system_items
4059: WHERE inventory_item_id = p_INVENTORY_ITEM_ID
4060: AND organization_id = p_ORGANIZATION_ID;
4061: RETURN TRUE;
4062: EXCEPTION

Line 4839: FROM mtl_system_items_b

4835: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4836: LOOP
4837: SELECT nvl(ib_item_instance_class,'X')
4838: INTO l_link_type
4839: FROM mtl_system_items_b
4840: WHERE inventory_item_id=p_instance_header_tbl(l_link).inventory_item_id
4841: AND organization_id=p_instance_header_tbl(l_link).vld_organization_id;
4842:
4843: IF l_link_type='LINK'

Line 5104: mtl_system_items msi

5100: mmt.trx_source_line_id,
5101: NULL lot_number
5102: FROM mtl_unit_transactions mut,
5103: mtl_material_transactions mmt,
5104: mtl_system_items msi
5105: WHERE mut.serial_number = p_serial_number
5106: AND mut.inventory_item_id = p_inventory_item_id
5107: AND mmt.transaction_id = mut.transaction_id
5108: AND msi.inventory_item_id = mut.inventory_item_id

Line 5136: mtl_system_items msi

5132: mtln.lot_number
5133: FROM mtl_unit_transactions mut,
5134: mtl_transaction_lot_numbers mtln,
5135: mtl_material_transactions mmt,
5136: mtl_system_items msi
5137: WHERE mut.serial_number = p_serial_number
5138: AND mut.inventory_item_id = p_inventory_item_id
5139: AND mtln.organization_id = mut.organization_id
5140: AND mtln.transaction_date = mut.transaction_date

Line 6100: FROM mtl_system_items_b

6096: END IF;
6097: ELSE
6098: SELECT eam_item_type
6099: INTO l_eam
6100: FROM mtl_system_items_b
6101: WHERE inventory_item_id = p_inventory_item_id
6102: AND organization_id = p_organization_id;
6103:
6104: IF l_eam IN (1,3)

Line 6441: mtl_system_items msi

6437: nvl(csi_utl_pkg.get_lot_ctrl_code(p_transaction_id),msi.lot_control_code) lot_control_code, -- Added for bug#14835893
6438: msi.serial_number_control_code,
6439: msi.primary_uom_code
6440: FROM mtl_unit_transactions mut,
6441: mtl_system_items msi
6442: WHERE mut.serial_number = p_serial_number
6443: AND mut.inventory_item_id = p_inventory_item_id
6444: AND msi.organization_id = mut.organization_id
6445: AND msi.inventory_item_id = mut.inventory_item_id