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.CSD_PROCESS_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 288: from mtl_system_items

284: l_org_id := cs_std.get_item_valdn_orgzn_id;
285:
286: select 'X'
287: into l_dummy
288: from mtl_system_items
289: where inventory_item_id = p_inventory_item_id
290: and organization_id = l_org_id
291: and sysdate between nvl(start_date_active,sysdate)
292: and nvl(end_date_active, sysdate);

Line 664: from mtl_system_items_B

660:
661: begin
662: select MATERIAL_BILLABLE_FLAG
663: into l_billing_type
664: from mtl_system_items_B
665: where inventory_item_id = p_inventory_item_id
666: and organization_id = l_org_id
667: and sysdate between nvl(start_date_active,sysdate)
668: and nvl(end_date_active, sysdate);

Line 876: from mtl_system_items_kfv

872: p_org_id IN NUMBER) IS
873: Select
874: serial_number_control_code,
875: comms_nl_trackable_flag
876: from mtl_system_items_kfv
877: where inventory_item_id = p_inv_item_id
878: and organization_id = p_org_id;
879:
880: --picking_rule_changes for R12

Line 4643: from mtl_system_items

4639: BEGIN
4640:
4641: select serial_number_control_code
4642: into l_serial_code
4643: from mtl_system_items
4644: where inventory_item_id = p_inv_item_id
4645: and organization_id = cs_std.get_item_valdn_orgzn_id;
4646:
4647: IF l_serial_code = 1 then

Line 6246: from MTL_SYSTEM_ITEMS_B

6242:
6243: --bug#13498183
6244: SELECT SERIAL_NUMBER_CONTROL_CODE
6245: INTO l_SERIAL_CONTROL_CODE
6246: from MTL_SYSTEM_ITEMS_B
6247: WHERE INVENTORY_ITEM_ID = p_inventory_item_id AND ORGANIZATION_ID = p_org_id;
6248: --bug#13498183
6249:
6250: -- if negative inventory is not allowed and the subinv is specified in the