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

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

Line 401: FROM mtl_system_items

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

Line 507: FROM mtl_system_items

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

Line 668: from MTL_SYSTEM_ITEMS_B

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

Line 870: from MTL_SYSTEM_ITEMS_B

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

Line 1109: FROM mtl_system_items

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

Line 1243: from MTL_SYSTEM_ITEMS_B

1239: l_item_id NUMBER;
1240: --
1241: CURSOR CTO_CUR(p_base_model IN NUMBER) IS
1242: select distinct inventory_item_id
1243: from MTL_SYSTEM_ITEMS_B
1244: where base_item_id = p_base_model
1245: and inventory_item_id <> p_inv_item_id;
1246: --
1247: comp_error EXCEPTION;

Line 1303: from MTL_SYSTEM_ITEMS_B

1299: IF l_serial_type = 1
1300: THEN
1301: select base_item_id
1302: into l_base_item_id
1303: from MTL_SYSTEM_ITEMS_B
1304: where inventory_item_id = p_inv_item_id
1305: and organization_id = p_inv_org_id;
1306: --
1307: IF l_base_item_id IS NOT NULL THEN

Line 1656: FROM mtl_system_items

1652: l_stack_err_msg BOOLEAN DEFAULT TRUE;
1653: --
1654: CURSOR c1 is
1655: SELECT lot_control_code
1656: FROM mtl_system_items
1657: WHERE inventory_item_id = p_inv_item_id
1658: AND organization_id = p_inv_org_id
1659: AND enabled_flag = 'Y'
1660: AND nvl (start_date_active, sysdate) <= sysdate

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

1947: (p_uom_code => p_uom_code ,
1948: p_item_id => p_inv_item_id ,
1949: p_organization_id => p_inv_org_id) ) THEN
1950:
1951: -- check for the existance of primary uom code in mtl_system_items for the unit of measure code passed
1952: BEGIN
1953: SELECT primary_uom_code
1954: INTO to_unit
1955: FROM mtl_system_items

Line 1955: FROM mtl_system_items

1951: -- check for the existance of primary uom code in mtl_system_items for the unit of measure code passed
1952: BEGIN
1953: SELECT primary_uom_code
1954: INTO to_unit
1955: FROM mtl_system_items
1956: WHERE inventory_item_id = p_inv_item_id
1957: AND organization_id = p_inv_org_id
1958: AND enabled_flag = 'Y'
1959: AND nvl (start_date_active, sysdate) <= sysdate

Line 2446: from mtl_system_items

2442: l_return_value := TRUE;
2443: Else
2444: select serial_number_control_code
2445: into l_serial_code
2446: from mtl_system_items
2447: where inventory_item_id = p_instance_rec.inventory_item_id
2448: and organization_id = p_instance_rec.vld_organization_id;
2449: l_return_value := TRUE;
2450: End if;

Line 3371: FROM mtl_system_items

3367: -- value. If it is not under serial_control, then serial number MUST be NULL
3368: --
3369: CURSOR c1 is
3370: SELECT serial_number_control_code
3371: FROM mtl_system_items
3372: WHERE inventory_item_id = p_inv_item_id
3373: AND organization_id = p_inv_org_id
3374: AND enabled_flag = 'Y'
3375: AND nvl (start_date_active, sysdate) <= sysdate

Line 3974: FROM mtl_system_items

3970:
3971:
3972: SELECT '1'
3973: INTO l_dummy
3974: FROM mtl_system_items
3975: WHERE inventory_item_id = p_INVENTORY_ITEM_ID
3976: AND organization_id = p_ORGANIZATION_ID;
3977: RETURN TRUE;
3978: EXCEPTION

Line 4753: FROM mtl_system_items_b

4749: FOR l_link IN p_instance_header_tbl.FIRST..p_instance_header_tbl.LAST
4750: LOOP
4751: SELECT nvl(ib_item_instance_class,'X')
4752: INTO l_link_type
4753: FROM mtl_system_items_b
4754: WHERE inventory_item_id=p_instance_header_tbl(l_link).inventory_item_id
4755: AND organization_id=p_instance_header_tbl(l_link).vld_organization_id;
4756:
4757: IF l_link_type='LINK'

Line 5847: FROM mtl_system_items_b

5843: END IF;
5844: ELSE
5845: SELECT eam_item_type
5846: INTO l_eam
5847: FROM mtl_system_items_b
5848: WHERE inventory_item_id = p_inventory_item_id
5849: AND organization_id = p_organization_id;
5850:
5851: IF l_eam IN (1,3)

Line 6154: mtl_system_items msi

6150: msi.lot_control_code,
6151: msi.serial_number_control_code,
6152: msi.primary_uom_code
6153: FROM mtl_unit_transactions mut,
6154: mtl_system_items msi
6155: WHERE mut.serial_number = p_serial_number
6156: AND mut.inventory_item_id = p_inventory_item_id
6157: AND msi.organization_id = mut.organization_id
6158: AND msi.inventory_item_id = mut.inventory_item_id