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.INV_LABEL_PVT8 dependencies on MTL_CUSTOMER_ITEMS

Line 879: FROM mtl_customer_items mci

875: , mci.attribute12
876: , mci.attribute13
877: , mci.attribute14
878: , mci.attribute15
879: FROM mtl_customer_items mci
880: WHERE mci.customer_item_id = p_customer_item_id;
881:
882: CURSOR c_lot_number(p_organization_id NUMBER, p_inventory_item_id NUMBER, p_lot_number VARCHAR2) IS
883: SELECT

Line 1226: , mtl_customer_items mci_oi

1222: 'CUST', mci_oi.customer_item_number,
1223: 'INT', msik_oi.concatenated_segments,
1224: msik_oi.concatenated_segments)) ordered_item
1225: FROM oe_order_lines_all oeol
1226: , mtl_customer_items mci_oi
1227: , mtl_system_items_kfv msik_oi
1228: WHERE oeol.line_id = p_line_id
1229: AND oeol.ordered_item_id = mci_oi.customer_item_id (+)
1230: AND oeol.ordered_item_id = msik_oi.inventory_item_id (+)