APPS.INV_LOT_ATTRIBUTE_SYNC_PVT dependencies on MTL_LOTATT_SYNC_REPORT_TEMP

Line 143: from MTL_LOTATT_SYNC_REPORT_TEMP

139: n_attribute7,
140: n_attribute8,
141: n_attribute9,
142: n_attribute10
143: from MTL_LOTATT_SYNC_REPORT_TEMP
144: where flag = 1
145: and group_id = p_group_id;
146:
147: cursor c_dest_lotatt(p_item_id number,p_lot_number varchar) IS

Line 151: from MTL_LOTATT_SYNC_REPORT_TEMP

147: cursor c_dest_lotatt(p_item_id number,p_lot_number varchar) IS
148: select organization_id,
149: inventory_item_id,
150: lot_number
151: from MTL_LOTATT_SYNC_REPORT_TEMP
152: where lot_number = p_lot_number
153: and inventory_item_id = p_item_id
154: and flag = 2
155: and group_id = p_group_id;