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 977: FROM mtl_customer_items mci

973: , mci.attribute12
974: , mci.attribute13
975: , mci.attribute14
976: , mci.attribute15
977: FROM mtl_customer_items mci
978: WHERE mci.customer_item_id = p_customer_item_id;
979:
980: CURSOR c_lot_number(p_organization_id NUMBER, p_inventory_item_id NUMBER, p_lot_number VARCHAR2) IS
981: SELECT

Line 1324: , mtl_customer_items mci_oi

1320: 'CUST', mci_oi.customer_item_number,
1321: 'INT', msik_oi.concatenated_segments,
1322: msik_oi.concatenated_segments)) ordered_item
1323: FROM oe_order_lines_all oeol
1324: , mtl_customer_items mci_oi
1325: , mtl_system_items_kfv msik_oi
1326: WHERE oeol.line_id = p_line_id
1327: AND oeol.ordered_item_id = mci_oi.customer_item_id (+)
1328: AND oeol.ordered_item_id = msik_oi.inventory_item_id (+)