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.AHL_CMP_PVT dependencies on MTL_LOT_NUMBERS

Line 475: FROM mtl_lot_numbers

471: CURSOR mtl_lot_num_csr (p_org_id In NUMBER,
472: p_inventory_item_id IN NUMBER,
473: p_lot_number IN VARCHAR2) IS
474: SELECT 'x'
475: FROM mtl_lot_numbers
476: WHERE organization_id = p_org_id
477: AND inventory_item_id = p_inventory_item_id
478: AND lot_number = p_lot_number
479: AND nvl(disable_flag,2) = 2;

Line 841: FROM mtl_lot_numbers

837: D_ATTRIBUTE1, D_ATTRIBUTE2, D_ATTRIBUTE3, D_ATTRIBUTE4, D_ATTRIBUTE5,
838: D_ATTRIBUTE6, D_ATTRIBUTE7, D_ATTRIBUTE8, D_ATTRIBUTE9, D_ATTRIBUTE10,
839: N_ATTRIBUTE1, N_ATTRIBUTE2, N_ATTRIBUTE3, N_ATTRIBUTE4, N_ATTRIBUTE5,
840: N_ATTRIBUTE6, N_ATTRIBUTE7, N_ATTRIBUTE8, N_ATTRIBUTE9, N_ATTRIBUTE10
841: FROM mtl_lot_numbers
842: where lot_number = p_lot_number;
843:
844: l_lot_dff_rec get_lot_dff_attrib%ROWTYPE;
845: