APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_LOT_NUMBERS

Line 2152: FROM mtl_lot_numbers

2148: CURSOR mtl_lot_num_csr (p_org_id In NUMBER,
2149: p_inventory_item_id IN NUMBER,
2150: p_lot_number IN VARCHAR2) IS
2151: SELECT 'x'
2152: FROM mtl_lot_numbers
2153: WHERE organization_id = p_org_id
2154: AND inventory_item_id = p_inventory_item_id
2155: AND lot_number = p_lot_number
2156: AND nvl(disable_flag,2) = 2;

Line 4136: FROM mtl_lot_numbers

4132: D_ATTRIBUTE1, D_ATTRIBUTE2, D_ATTRIBUTE3, D_ATTRIBUTE4, D_ATTRIBUTE5,
4133: D_ATTRIBUTE6, D_ATTRIBUTE7, D_ATTRIBUTE8, D_ATTRIBUTE9, D_ATTRIBUTE10,
4134: N_ATTRIBUTE1, N_ATTRIBUTE2, N_ATTRIBUTE3, N_ATTRIBUTE4, N_ATTRIBUTE5,
4135: N_ATTRIBUTE6, N_ATTRIBUTE7, N_ATTRIBUTE8, N_ATTRIBUTE9, N_ATTRIBUTE10
4136: FROM mtl_lot_numbers
4137: where lot_number = p_lot_number;
4138:
4139: l_lot_dff_rec get_lot_dff_attrib%ROWTYPE;
4140: -- Fix for bug# 8607839(FP for Bug # 8575782) -- end

Line 5175: l_inv_lot_no mtl_lot_numbers.lot_number%TYPE;

5171: l_dup_disposition VARCHAR2(1);
5172: l_inv_item_id NUMBER;
5173: l_inv_rev mtl_material_transactions.revision%TYPE;
5174: l_inv_serial mtl_serial_numbers.serial_number%TYPE;
5175: l_inv_lot_no mtl_lot_numbers.lot_number%TYPE;
5176: l_wo_id NUMBER;
5177: l_track_flag BOOLEAN;
5178: l_cnt_disposition NUMBER;
5179: l_pend_count NUMBER;