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.ENI_ITEMS_STAR_PKG dependencies on MTL_PARAMETERS

Line 39: -- mtl_parameters mtp,

35: -- mtp.organization_code,
36: COUNT(category_id)
37: FROM
38: mtl_system_items_kfv mti,
39: -- mtl_parameters mtp,
40: mtl_item_categories cat
41: WHERE
42: mti.inventory_item_id = cat.inventory_item_id AND
43: mti.organization_id = cat.organization_id AND

Line 424: mtl_parameters mtp,

420: mti.weight_uom_code,
421: mti.volume_uom_code,
422: mti.eam_item_type
423: FROM mtl_system_items_b_kfv mti,
424: mtl_parameters mtp,
425: mtl_item_categories mic ,
426: mtl_item_categories mic1 ,
427: mtl_item_categories mic2 ,
428: mtl_categories_b_kfv kfv ,

Line 600: mtl_parameters mtp,

596: mti.creation_date,
597: mti.last_update_date
598: FROM
599: mtl_system_items_b_kfv mti,
600: mtl_parameters mtp,
601: mtl_item_categories mic,
602: mtl_item_categories mic1,
603: mtl_item_categories mic2,
604: mtl_categories_b_kfv kfv,

Line 845: mtl_parameters mtp

841: 'Unassigned',
842: mti.creation_date,
843: mti.last_update_date
844: FROM mtl_system_items_b_kfv mti,
845: mtl_parameters mtp
846: WHERE mti.inventory_item_id = p_inventory_item_id
847: AND mti.organization_id = p_organization_id
848: AND mti.organization_id= mtp.organization_id;
849:

Line 921: , mtl_parameters b

917: ,mti.weight_uom_code
918: ,mti.volume_uom_code
919: ,mti.eam_item_type
920: FROM mtl_system_items_b_kfv mti
921: , mtl_parameters b
922: WHERE mti.inventory_item_id = p_inventory_item_id
923: AND mti.organization_id = b.organization_id
924: AND b.master_organization_id = p_organization_id;
925: -- updates to child-org-level attributes are confined to that organization

Line 953: FROM mtl_parameters

949:
950: isMasterOrg := 0;
951:
952: SELECT COUNT(master_organization_id) INTO isMasterOrg
953: FROM mtl_parameters
954: WHERE master_organization_id = p_organization_id AND ROWNUM < 2;
955:
956: IF isMasterOrg = 1 THEN
957: FOR c_items_in_master_rec IN c_items_in_master

Line 1246: FROM mtl_parameters mp

1242: WHERE
1243: msi.inventory_item_id = p_inventory_item_id
1244: AND (msi.organization_id = p_organization_id
1245: or msi.organization_id in (SELECT mp.organization_id
1246: FROM mtl_parameters mp
1247: WHERE
1248: mp.master_organization_id = p_organization_id))
1249: AND mic.inventory_item_id (+) = msi.inventory_item_id
1250: AND mic.organization_id (+) = msi.organization_id

Line 1505: , mtl_parameters mtp

1501: , item.creation_date
1502: , item.last_update_date
1503: FROM mtl_system_items_interface interface
1504: , mtl_system_items_b_kfv item
1505: , mtl_parameters mtp
1506: , mtl_item_categories mic
1507: , mtl_categories_b_kfv kfv
1508: , mtl_item_categories mic1
1509: , mtl_categories_b_kfv kfv1

Line 1633: , mtl_parameters mtp

1629: , item.creation_date
1630: , item.last_update_date
1631: FROM mtl_system_items_interface interface
1632: , mtl_system_items_b_kfv item
1633: , mtl_parameters mtp
1634: , mtl_item_categories mic
1635: , mtl_categories_b_kfv kfv
1636: , mtl_item_categories mic1
1637: , mtl_categories_b_kfv kfv1

Line 1867: ,mtl_parameters mp

1863: CURSOR icoi_csr (p_set_process_id NUMBER) IS
1864: SELECT mici.inventory_item_id
1865: ,mp.organization_id
1866: FROM mtl_item_categories_interface mici
1867: ,mtl_parameters mp
1868: WHERE mici.set_process_id = p_set_process_id
1869: AND mici.request_id = l_conc_request_id
1870: AND mici.process_flag = l_process_flag
1871: AND ( mici.category_set_id = l_INV_category_set_id